Connecting to existing database with VB 2005 Express
When I select an existing SQL database and try to connect I receive the error:
Failed to generate a user interface of SQL Server due to a failure in starting the process for the user instance. The Connection will be closed.
Any Ideas? I am using WinXP Home Edition, have installed SQL 2005 Express.
I do not know why but on my last couple of trys it started working.
A change I noticed was before when I selected the datasource the text was something like .//sql?(SQLEXPRESS).
I can not remember exact wording.
The times it worked, when I selected the datasource the text was Microsoft SQL Server Database File(SQL Client).
I hope it keeps working..
Thanks
Mike
I think I found the problem, I was not the first one to use the computer the days with the problem. Even SSEUtil gives the same error. When I switched users to the one that signed on first, SSEUtil worked. I tried signing off of the other computer users and restarting the SQL Server. SSEUtil still could not get the server to respond.
It looks like bottom line....If you need to use a sqldatabase with visual basic 2005 express, make sure you signed on the computer first or reboot before you start or return to your database project.
Mike
