August 24, 2007 at 3:57 am
I have an intel mac mini with Parallels to run XP Pro, plus i i have also tried the following on my P4 IBM laptop:
I am learning VB and SQL so i'm very new to everything. I've got visual studio express, also visual web developer and installed SQL server 2005 express as well. I'm trying some of the examples in the videos accompanying the SQL website, a problem occurs where i've set up a form on VS Express, and then clicked on 'Add new item' and selected Sql database and clicked on Add, but i keep getting 'Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances. I have the same problem on both machines, what am i doing wrong? I've connected myself to the SQL database when i've tried SQL Server studio management express when it asks me to login. I cant seem to find where i would be able to enable the user instance? As far as i am aware i've installed everything as it should be. I have tried some of the suggestions via google and some of the other forums, what am i doing wrong?
August 24, 2007 at 4:47 pm
I think you have standard Express it is limited so go the link below and download the Express Advanced and uninstall the standard Express and install the new one. Then follow the instructions below carefully and configure the Express for development.
http://msdn2.microsoft.com/en-us/express/bb410792.aspx
When you have completed the following configuration you go to the link below and configure mixed authentication and enable the system admin account so you can use an account to login. It is a lot of work because most services in SQL Server Express and the developer editions comes disabled by default.
Steps for Configuration Manager:
Make Browser service automatic from Manual in SQL Server 2005 services
Go to Network Configuration in Configuration Manager
Enable TCP/IP
Enable Named Pipes
Surface Area Configuration tool steps:
Go to Surface Area configuration for services and Connection
In Database Engine click on Remote Connection
In there change to Local and Remote
And choose both TCP/IP and Named Pipes it is the last option.
You need to change to mixed authentication mode, but because you installed with Windows Authentication the SA account is disabled so you have to enable it and add password to it. Try the link below for details.
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
Post again if you still need help.
Kind regards,
Gift Peddie
August 24, 2007 at 4:55 pm
You can enable user instances on SQL Server Express by executing
sp_configure 'user instances enabled','1'
(connect with management Studio, and execute the above line)
By default user instances are disabled.
Regards,
Andras
August 25, 2007 at 5:59 am
Andras, how do i execute this line? Where and how do i put this information, i dont understand?
August 25, 2007 at 1:58 pm
If you have management studio express installed, then connect to the database, press Ctrl-N (new query window), and then type in the commands, Ctrl-X will execute it.
In case you do not have it installed, get a command window (Start->Run type cmd)
execute in the command window the following command:
osql -S(local)\SQLExpress -E
This will connect to the database. Here you can type in the configure command
press enter, then type in GO and press enter
Regards,
Andras
August 29, 2007 at 2:30 am
Thanks Andras, it now works fine on my laptop, but not through Parallels? Thanks so much for your help. I've learnt VB 2005 from Michael Halversons excellent book, can you recommend any other books for learning SQL and databases vie VB, Web Developer and also the next steps in VB and anything else i might find useful?
August 29, 2007 at 3:18 am
I'm glad I could help. Concerning books I'd start a new topic, so others could find the answers in the future. There are some book recommendations on the site already, but they are more SQL related than VB.
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=289522
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=328939
Regards,
Andras
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply