i want to upload my website on web server,Can anybody tell me what will be my connection string for SqlExpress database?

Pravinkumar Birajdar

14y3.7k.NET

I have tried connection string as IP:portno & ip\\SQLEXPRESS

but it all giving an error message

Plz tell me the connection string

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Neha Sharma14y ago
Pravin,

Make sure that the connectionstring is working on Local mssql management studio.
0
sharath kumar14y ago
http://www.connectionstrings.com/sql-server-2008
0
Pravinkumar Birajdar14y ago
It still giving error as "Internet Server Error" while accessing my application through internet
0
Neha Sharma14y ago
hii

When i have database on my local PC:

"Data Source=neha-pc\\sqlexpress;DataBase=dbname; user ID=abc; password=abc";

When I have database on server:

"Data Source=173.248.170.250;DataBase=dbname; user ID=abc; password=abc";

or you can try with "." also.

But in case you are unable to find the exact data source you can go with the hosting provider technical support team they ll manage the connection string or allow remote connection to allow.

if it helps you mark it as answer,else let me know the next issue.
0
Shivanand Arur14y ago
Data Source=Your Port Number; User id=User ID; Password=Your Password; Initial Catalog=Your Database Name;" providerName="System.Data.SqlClient"/>

Try using this...
0