Connecting to SQL Server Express 2005from Visual Basic 2005

  • Need help! I am trying to make a connection to a database in SQL Server Express 2005 from Visual Basic 2005. I am getting an error . . . "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed".

    Or I would like to or create a new SQL Server database from Visual Basic (Database Explorer), but the "Create New SQL Server Database" is faded out. ? ? ?

  • Can you post the VB.NET code that is attempting to connect to a database?

    What authentication method did you specify when installing SQL Server Express, mixed or Windows?

    What OS is the install on?

  • Actually, I am connecting through Visual Basic (Visual Studio Express) not by code I have written. The connection is made through the Database Explorer, so is a new database created. I am using windows authenication and XP Professional. I can create databases with the server, but can connect to it from Visual Basic.

    Thanks for any helP!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply