SqlConnection problem

Question

My sqlconnection is SqlConnection(@"Data Source = John\Administrator; Initial Catalog = TicketingSystem; Integrated Security = true;");

I try to connect to the server but i cant this error pops up A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I think that the error is in the Data Source but I cant find it. When I open Microsoft SQL Server Management Studio it says that my server is "John" and the Connection is "John\Administrator" so please help me.

Answer 1

if the server is actually called 'John', then that is your data source. When you're running locally, you could probably just set Data Source=(local), tho.

Other than that, you'd need to specify a user to connect with

http://connectionstrings.com/

Answer 2

The Integrated Security=True part of your connection string means "connect as the current user". When you run an asp.net page, the current user by default is a special ASPNET account. You can "impersonate" a different user, but I'm guessing you haven't done that and the ASPNET user doesn't have access to your database.

Answer 3

It's possible that your server isn't configured to allow remote connections. You can check this in the SQL Server Configuration Manager tool.

Have a look here too.

Answer 4

Your Data Source is the server. So you only need "John", not "John\Administrator", that's not a valid data source. You're using integrated security which means it will use the same username as the program is running under and it's credentials, if it's on the domain.

Answer 5

An easy way to get your connection string is

1. create a file called x.udl
2. double click on it
3. Follow wizard
4. open x.udl file in notepad
5. and inside you will find your connection string.

Answer 6

When I open Microsoft SQL Server Management Studio it says that my server is "John" and the Connection is "John\Administrator" so please help me.

That means you're logged on to your server's default instance (John) as Administrator. Remove the \Administrator part, and you should be good to go!

var cn = new SqlConnection(@"Data Source = John; Initial Catalog = TicketingSystem; Integrated Security = true;");

Answer 7

You can get your connectionstring from SQL Server Management Studio from the properties window.

Just click on the John\Administrator node, then press F4 to open the properties window, and search for the connection string there...

Answer 8

Data Source = John\Administrator

Specifying John\Administrator as your Data Source, means ADO should connect to the SQL instance named "Administrator" on the server "John". Although instances are quite useful, I don't think that's what you want. (SQL Instances allow you to run multiple copies of SQL Server on one server)

As "d." mentioned, you will need to change Data Source to the correct server name or (local) ((local)\SQLEXPRESS if it's SQL Express).

Also, Integrated Security=true means that the user running ASP.NET, or at least the AppPool, will need access to the database. (The default is NETWORK SERVICE on pre-Windows 7, IUSR / IIS_USRS on 7).

If, however, you use ASP.NET windows authentication with <identity impersonate="true" /> then the user accessing the site will need access to the database.