Connectionstring to server isn't working in ASP.NET

Question

So I'm trying to set up a connectionstring in ASP.NET to connect to a SQL Server. I've got the servername and that's the structure I'm currently using.

 <add name="CRMSQL" connectionString="Data Source=servername\Instance;Initial Catalog=crm;User ID='CRM';Password='****';Integrated Security=True" providerName="System.Data.SqlClient" />

I know that the username and the password are right and for the Servername I use something like U444324.And as the instance name I use the name which pops up when I execute:
SELECT @@servername
What are possible sources of error?

Isn't working is not a valid issue description. What is the exact error ? — Raptor
– Raptor, Commented Sep 14, 2015 at 9:28
Have you tried to connect to the DB with Sql Server Management Studio? If so then try to use in Data Source exact what you have in the Server Name field of the Connect to Server window — Dmitry Bogomolov
– Dmitry Bogomolov, Commented Sep 14, 2015 at 9:33
@doctor_Nick42 So I connected it in Visual Studio with the SQL Server Object Explorer and it worked. — aha364636
– aha364636, Commented Sep 14, 2015 at 9:37

Suprabhat Biswal · Accepted Answer · 2015-09-14 09:37:41Z

1

Replace Integrated Security=True with Persist Security Info=True

Persist Security = true means that the Password used for SQL authentication is not removed from the ConnectionString property of the connection.

When Integrated Security = true is used then the Persist Security is completely irelevant since it only applies to SQL authentication, not to windows/Integrated/SSPI.

Reference : Differance Between Persist Security Info And Integrated Security

answered Sep 14, 2015 at 9:37

Suprabhat Biswal

3,2561 gold badge23 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Izzy · Accepted Answer · 2015-09-14 09:37:18Z

1

Create an empty text file
Change the extension to .udl
Once created, double click on the created file.
You will be presented with a GUI
Follow the steps in Connection tab and click on Test Connection
If successfull, click OK
Then right click on the file and open with note pad
Copy the connection string and replace it with your current one.

answered Sep 14, 2015 at 9:37

Izzy

6,8988 gold badges44 silver badges92 bronze badges

Collectives™ on Stack Overflow

Connectionstring to server isn't working in ASP.NET

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related