Connecting to SQL Server 2000 accross a Network

[ColdWaterBlue]

I am trying to access SQL Server 2000 across a personal network. I am using the following connection string: "Data Source=\\GUITARCHORD\LABTRACK;Initial Catalog=LabTrack Server;Integrated Security=SSPI;User ID=someone,Password=pass" The name of the computer is GUITARCHORD, the name of the SQL Server instance is LABTRACK, and the name of the database I am trying to connect to is LABTRACK SERVER. The user id and password are the Windows Login for the computer that SQL Server is running on. SQL Server is running but I can only access it if I am working on the same computer. I am using VB.NET to try to access this server. I am getting the following error message: "SQL Server does not exist or access denied." I have tried every thing I could think of for a connection string, including using TCP/IP settings. Any suggestions would be extremely helpful. ------------------------ ColdWaterBlue - Rock On

[Colin Angus Mackay]

ColdWaterBlue wrote: Data Source=\\GUITARCHORD\LABTRACK You don't need the two leading slashes in the server name. Does this help?

---

Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

[ColdWaterBlue]

I actually just figured it out myself. The two front slashes are not needed, but you need to add a user to the SQL Server (in my case, add the 'Guest' user) and give it administrative rights over the database. The User ID and Password are no longer needed, since the Integrated Security uses a trusted connection. Thanks anyway. ------------------------ ColdWaterBlue - Rock On

[Colin Angus Mackay]

ColdWaterBlue wrote: add a user to the SQL Server (in my case, add the 'Guest' user) and give it administrative rights over the database Is giving admin rights to the guest user wise?

---

Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums