connection error

Hi guys, my asp.net web page was working fine on my laptop. Until i transferred it into my friend's.. an error msg popped out. My SQL Northwind database was been copied over but still there seems to be a problem with the connection, can any one help me?
Personal guess: You are using an sa username/password in the connection string, and the other server you are connecting to is not set up for SQL security, only Windows security.
Show the connection string you are using (with any passwords obscured, of course).
|||

SqlConnection conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=Northwind");

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = "SELECT * FROM tblDoor";

conn.Open();
//how to find out what user id to use?

|||Do you have SQL Server or MSDE? If SQL Server, then you should be able to use Enterprise Manager to try and figure out what the SA password is, as well as determining whether SQL Server security is enabled. If you have Enterprise manager, right click the SQL Server and select Porperties. In the properties window, go to the Security tab make sure authentication is set to SQL Server and Windows.|||oh it is working already, thanks man!

Connecting to SQL2005 express

Hi,
I'm trying to connect to (Northwind) SQL2005 express from VS2005 express
edition .
When I test the connection, I get the error:
"Generating user instances of SQL server is disabled. Use sp_configure 'User
instances enabled' to generate user instances".
I run sp_configure with the above command, but the issue remains.
Any ideas on this?
Many thanks in advance for any help
AntDoes this help?
http://blog.devstone.com/aaron/arch...01/09/1425.aspx
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:AD271F4A-E4F8-457C-98B5-7443C6910D42@.microsoft.com...
> Hi,
> I'm trying to connect to (Northwind) SQL2005 express from VS2005 express
> edition .
> When I test the connection, I get the error:
> "Generating user instances of SQL server is disabled. Use sp_configure
> 'User
> instances enabled' to generate user instances".
> I run sp_configure with the above command, but the issue remains.
> Any ideas on this?
> Many thanks in advance for any help
> Ant

Connecting to SQL2005 express

Hi,
I'm trying to connect to (Northwind) SQL2005 express from VS2005 express
edition .
When I test the connection, I get the error:
"Generating user instances of SQL server is disabled. Use sp_configure 'User
instances enabled' to generate user instances".
I run sp_configure with the above command, but the issue remains.
Any ideas on this?
Many thanks in advance for any help
Ant
Does this help?
http://blog.devstone.com/aaron/archive/2006/01/09/1425.aspx
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:AD271F4A-E4F8-457C-98B5-7443C6910D42@.microsoft.com...
> Hi,
> I'm trying to connect to (Northwind) SQL2005 express from VS2005 express
> edition .
> When I test the connection, I get the error:
> "Generating user instances of SQL server is disabled. Use sp_configure
> 'User
> instances enabled' to generate user instances".
> I run sp_configure with the above command, but the issue remains.
> Any ideas on this?
> Many thanks in advance for any help
> Ant

Connecting to SQL2005 express

Hi,
I'm trying to connect to (Northwind) SQL2005 express from VS2005 express
edition .
When I test the connection, I get the error:
"Generating user instances of SQL server is disabled. Use sp_configure 'User
instances enabled' to generate user instances".
I run sp_configure with the above command, but the issue remains.
Any ideas on this?
Many thanks in advance for any help
AntDoes this help?
http://blog.devstone.com/aaron/archive/2006/01/09/1425.aspx
--
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:AD271F4A-E4F8-457C-98B5-7443C6910D42@.microsoft.com...
> Hi,
> I'm trying to connect to (Northwind) SQL2005 express from VS2005 express
> edition .
> When I test the connection, I get the error:
> "Generating user instances of SQL server is disabled. Use sp_configure
> 'User
> instances enabled' to generate user instances".
> I run sp_configure with the above command, but the issue remains.
> Any ideas on this?
> Many thanks in advance for any help
> Ant