469,085 Members | 1,010 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,085 developers. It's quick & easy.

Can't connect to SQL server Northwind database

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 there a way to do this in Visual studio thanks

Dec 12 '06 #1
1 3157
podx (na***********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by D Bull | last post: by
8 posts views Thread by Igor Raytsin | last post: by
1 post views Thread by Jim Bunton | last post: by
2 posts views Thread by C#User | last post: by
4 posts views Thread by Zalak Dedhia via DotNetMonster.com | last post: by
2 posts views Thread by dennist685 | last post: by
9 posts views Thread by =?Utf-8?B?RnJpdHo=?= | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.