Showing posts with label generating. Show all posts
Showing posts with label generating. Show all posts

Tuesday, February 14, 2012

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