Posted by Erland Sommarskog on 12/13/06 23:01

podx (nate.eckstine@seattle.gov) writes:
> I am trying to connect to SQL 7.0 northwind database via visual studio
> 2005. But I can't open the connection. I get an error saying remote
> access is not allowed. But the remote access is ok. I can used the same
> login and connect to the sql server via enterprise manage.
>
> SqlConnection conn = new SqlConnection("Data
> Source=(sqlserver:1433);Initial Catalog=Northwind;User
> ID=me;Password=mypassword");
>
> The above is the string I am trying to use.

Is the name of the SQL Server machine realluy "sqlserver"? If SQL
Server is running on your local machine, try "(local)" instead.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]