7 Replies - 416 Views - Last Post: 15 April 2013 - 02:55 PM Rate Topic: -----

#1 Zuelajindi  Icon User is offline

  • D.I.C Head

Reputation: 4
  • View blog
  • Posts: 80
  • Joined: 09-October 12

Connection help to SQL Server in Visual Studio

Posted 11 April 2013 - 06:44 PM

I've been having difficulty getting with database files as this is what comes up.

Posted Image
Is This A Good Question/Topic? 0
  • +

Replies To: Connection help to SQL Server in Visual Studio

#2 _HAWK_  Icon User is online

  • Master(Of Foo)
  • member icon

Reputation: 1067
  • View blog
  • Posts: 4,178
  • Joined: 02-July 08

Re: Connection help to SQL Server in Visual Studio

Posted 11 April 2013 - 07:50 PM

Click the Advanced... button and see if your connected to the right sql instance.
Was This Post Helpful? 0
  • +
  • -

#3 Zuelajindi  Icon User is offline

  • D.I.C Head

Reputation: 4
  • View blog
  • Posts: 80
  • Joined: 09-October 12

Re: Connection help to SQL Server in Visual Studio

Posted 11 April 2013 - 09:32 PM

Thanks, but how does this help? How do I know if I am connected to the right instance?
Was This Post Helpful? 0
  • +
  • -

#4 _HAWK_  Icon User is online

  • Master(Of Foo)
  • member icon

Reputation: 1067
  • View blog
  • Posts: 4,178
  • Joined: 02-July 08

Re: Connection help to SQL Server in Visual Studio

Posted 11 April 2013 - 09:48 PM

You built the database, right? On your machine you can look up where it is by it's directory in:

C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.{your instance name}\MSSQL\{db name}

How many instances do you have in the dropdown anyway? Try diff ones and test connection.
Was This Post Helpful? 0
  • +
  • -

#5 Zuelajindi  Icon User is offline

  • D.I.C Head

Reputation: 4
  • View blog
  • Posts: 80
  • Joined: 09-October 12

Re: Connection help to SQL Server in Visual Studio

Posted 11 April 2013 - 10:11 PM

The database was premade; it's a class project downloaded.
Was This Post Helpful? 0
  • +
  • -

#6 Zuelajindi  Icon User is offline

  • D.I.C Head

Reputation: 4
  • View blog
  • Posts: 80
  • Joined: 09-October 12

Re: Connection help to SQL Server in Visual Studio

Posted 15 April 2013 - 01:09 PM

Help? Am I probably missing some key that connects me to the server?
Was This Post Helpful? 0
  • +
  • -

#7 CharlieMay  Icon User is online

  • This space intentionally left blank
  • member icon

Reputation: 1623
  • View blog
  • Posts: 5,201
  • Joined: 25-September 09

Re: Connection help to SQL Server in Visual Studio

Posted 15 April 2013 - 01:15 PM

This can be a lot of things. If you were to google sql error 26 you would find a plethora of different reasons.

SQL Server express disables remote access by default, you will have to turn on TCP/IP and maybe Named Pipes in the configuration console for your version of sqlserver.

What is behind that error, can you give us a screenshot of what you had selected when prior to getting that.

Give us some more details about the database. It appears you have selected a database file.
Was This Post Helpful? 0
  • +
  • -

#8 andrewsw  Icon User is offline

  • It's just been revoked!
  • member icon

Reputation: 3838
  • View blog
  • Posts: 13,596
  • Joined: 12-December 12

Re: Connection help to SQL Server in Visual Studio

Posted 15 April 2013 - 02:55 PM

The server is running..(if it is necessary to start it)? Start it using the Server Configuration Manager.

I apologise if this is an obvious point to you.

Here's a useful tidbit from SO:

Quote

Here is a simple method to troubleshoot connection issues:

Create an empty file called test.udl using a text editor
Double click the file test.udl, then specify your connection properties
Hit the "Test Connection" button.

This post has been edited by andrewsw: 15 April 2013 - 02:53 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1