Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ntokzen
Starting Member
3 Posts |
 Posted - 2008-11-25 : 18:07:34
|
Dim conString As String = "Data Source=192.168.0.3\SQLExpress,1433;Network Library=DBMSSOCN;Initial Catalog=SRC_VOTERS_ROLL.mdf;User ID=Theinventor;Password=Theinven1;"If you had that string then where will the blue part come from because i use windows Authenthication to connect to the server throught management studio. Please help me out Get hold of me anytime and anyplace |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-25 : 18:16:16
|
See www.connectionstrings.com
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Ntokzen
Starting Member
3 Posts |
Posted - 2008-11-25 : 18:29:25
|
| I got the connection string from there i thought you might have an Idea of what the heck is dat.Get hold of me anytime and anyplace |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-25 : 18:41:17
|
1) Initial catalog is the database name, not the file name.2) try replace user and password settings with either a) Integrated Security=SSPI b) Trusted_Connection=True
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Ntokzen
Starting Member
3 Posts |
Posted - 2008-11-25 : 19:05:16
|
| It is not working. Can some one please tell me where do I get da password and username. da other part is dat database role please tell me about that again.Get hold of me anytime and anyplace |
|
|
|
Shamil
Starting Member
5 Posts |
Posted - 2008-11-28 : 18:30:17
|
| You should release "SQL Server and Windows Authentication mode". Server Property->Security->check "SQL Server and Windows Authentication mode".Connection string for Windows Authentication - "Data Source=192.168.0.3\SQLExpress,1433;Network Library=DBMSSOCN;Initial Catalog=SRC_VOTERS_ROLL.mdf;"Connection string SQL Server Authentication - "Data Source=192.168.0.3\SQLExpress,1433;Network Library=DBMSSOCN;Initial Catalog=SRC_VOTERS_ROLL.mdf;User ID=Theinventor;Password=Theinven1;" |
|
|
|
|
|
|
Sql Server Connection string