Dear Alan , Now can you tell me what can i do in this situation... pls tell me benifical way that i'll give the permission or sort out this Problem.
On Sat, Mar 12, 2011 at 6:51 PM, Gourav vishnoi <[email protected]>wrote: > Dear Alan.. > > I check the > Control Panel >>>> Services >>>> MS Sql Server >> Logon as > > Its NT AUTHORITY\NETWORK .. > > A image is attached in mail.... > > > > > On Sat, Mar 12, 2011 at 10:04 AM, Alan Griggs <[email protected]>wrote: > >> No, I'm not talking about which SQL user, I am asking about which Windows >> user. >> >> What Windows user is SQL Server running under? >> >> As my initial instructions said, go to the Windows control panel services >> applet and see which user SQL Server is running as. >> >> >> On Fri, Mar 11, 2011 at 10:03 PM, Gourav vishnoi < >> [email protected]> wrote: >> >>> Dear alandgri , >>> >>> i am creating my Connection String through sa *credential* ..so i think >>> sa have all the rights read and write in the server.... >>> >>> >>> >>> On Fri, Mar 11, 2011 at 8:10 AM, alandgri <[email protected]>wrote: >>> >>>> In many cases, the user that SQL server is started as does not have >>>> privilege to access the network, or may not have access to read the >>>> particular file that it is trying to read. >>>> >>>> Look in the services applet and see which user SQL Server is running >>>> as, then log on as that user and see if you can read the file. >>>> >>>> Maybe try looking in the event logs for an error message as well. >>>> >>>> >>>> On Mar 10, 2:33 am, Gourav <[email protected]> wrote: >>>> > Hi All, >>>> > >>>> > I got some Error... >>>> > ________________________________________________________________ >>>> > The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server >>>> > "(null)" reported an error. The provider did not give any information >>>> > about the error. Cannot initialize the data source object of OLE DB >>>> > provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)". >>>> > _________________________________________________________________ >>>> > >>>> > I have done so much goggling but didn't get the solution. >>>> > Actually i am upload a Excel sheet through Open row set into SQL >>>> > Server 2008. >>>> > It is working fine when i operate this on single PC Sql.But when i am >>>> > operate same program into networks sql server it prompt Error.So >>>> > please anybody have idea about this then pls tell me .I'll wait for >>>> > reply..... >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML >>>> Web Services,.NET Remoting" group. >>>> To post to this group, send email to [email protected] >>>> To unsubscribe from this group, send email to >>>> [email protected] >>>> For more options, visit this group at >>>> http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en >>>> or visit the group website at http://megasolutions.net >>>> >>> >>> >>> >>> -- >>> Warm Regards :- >>> Gourav Vishnoi >>> +91-9871157845 ( M ) >>> >> >> > > > -- > Warm Regards :- > Gourav Vishnoi > +91-9871157845 ( M ) > -- Warm Regards :- Gourav Vishnoi +91-9871157845 ( M ) -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
