Very Basic Question - Sorry

Very Basic Question - Sorry

• r3n

  I am starting using VS.NET with data for the first time and have a similar problem.

  My situation: VS .NET 2003, SQL Server Express 2005, both running on the same PC (WIndows Server 2003). My SQL Server Express is installed with integrated Windows security and left everything to the defaults.

  I drag a sqlConnection1 from the Data toolbox to the project. When I try to create a New Connection in the ConnectionString property using the Data Link Properties wizard, my database server appears in the drop down list for item 1 (Select or enter a server name). For item 2, I Use Windows Integrated security. When I click the drop down button for item 3 (Select the database on the server:), it hangs for a while and then the following dialog box pops up:

  [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

  followed by:

  Login failed. Catalog information cannot be retrieved.
  

  What have I not done right In the Provider tab in Data Link Properties , the item selected was Microsoft OLE DB Provider for SQL Server.

  In my Server Explorer in VS .NET 2003, I can see my database server, and also my database that I am trying to access, and they are all online (no red X'es)

  I re-tried with Use a specific user name and password and used my Windows credentials but it gives the same error messages.

  Thanks in advance.

  KK

  
  

• s o

  Hi adams and thanks for your responce.....

  I download this application form a site ... so it is ready.

  I first installed MSVS.NET 2005 and SQL Server 2005 i order to be able to run it.

  I attached the DB file to the application, but the same error appeare when i check the connection:

  [DBNETLIB]ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

  What can i do now !

  Regards

  Reta

  
  

• IGiberson

  Reta,

  Please take a look at the following blog which describes in detail how to troubleshoot connection failures with SQL Server 2005 Express.

  http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

  Jimmy

  
  
  

• Vahid66

  This is because, as Paul mentioned, the server has not authenticated yet. You need to manually type in the server name. The default instance and format is "computername\SQLEXPRESS"

  The easiest way to find out exactly is to open Management Studio and look at the server name it's populating automatically.

  Also, if you can't connect through Management Studio, you can't connect through a connection string.

  Step 1: Ensure you can connect to the server successfully through Management Studio.
  Step 2: Copy the Server Name from the field in the Management Studio logon prompt.
  Step 3: Paste the server name and drop the list of db's.

  You should now see them.

  Adamus

  
  
  

• HMariana

  Thanks for all the responses. Got it! I have to manually type in the instance name in the field for server. It was confusing because I thought picking from the drop down list was suffficient.

  
  

• Jeon

  You wrote an application prior to the installation of SQL Server 2005 EE and then installed it, and now you're getting an error

  Were you running SQL Server 2000 when you wrote the application

  As far as attaching the file, you need to download and install the management studio. This will allow you to attach files.

  Adamus

  
  
  

• c28560

  Hi,

  What did you use as server name I'm not sure of the default instance name but I think its ".\SQLEXPRESS" with the . and \ preceeding the instance name. Also, you can try creating a user in Sql server and use that username and password to log-on to the SqlServer. See if it would work.

  cheers,

  Paul June A. Domag

  
  
  
• Very Basic Question - Sorry