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 |
|
cjlindstrom
Starting Member
3 Posts |
 Posted - 2006-02-04 : 01:37:38
|
| I'm trying to link tables to SQLExpress. In my dev environment I have SQLExpress on my dev machine. The tables are linked just fine via a SQL Native Client Machine DSN. I have configured SQLExpress to allow mixed mode authentication. If I try to connect to SQLExpress from a different machine (using same named DSN but using SQL authentication) it will ask me for the password every attempt to access the tables. If I run SQLExpress Manager I can connect via SQL authentication just fine. I have added the userid and pwd to the connect string but it still won't authenticate properly.What I would like to use is a DSN-less connection string in the tabledef.connnection to connect to the db so I can programmatically change the links.What is the proper syntax for a tabledef connnect string that attaches to a SQLExpress database via the SQL Native client using SQL server authentication?Thanks in advance.PS not sure if this is in the right forum. Should it be in SQLExpress forum. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-09 : 13:27:32
|
| www.connectionstrings.com |
 |
|
|
cjlindstrom
Starting Member
3 Posts |
Posted - 2006-02-10 : 13:33:36
|
| Actually I have already tried the standard connect strings. And the one on www.connectstrings.com is a typical connect string. The problem is that even when I add the username and password in the connects string for the linked table connection, then refresh the link, the next time I access the table I still get asked for a user name and password. It is like Access will not passed the login information properly. |
|
|
|
mikewa
Microsoft SQL Server Product Team
84 Posts |
Posted - 2006-02-14 : 12:15:56
|
| Check out the Microsoft Knowledge Base (http://support.microsoft.com) for articles about DSN-less connection and relinking tables, there are a number of different approaches you can use.As far as being prompted when you open the table, saving the user id and password is an option in the UI when you first link a table that you need to check. This stores the user ID and password in a clear text connection string that can easily be viewed through your TableDef so it is not recomended. If you don't want users to be prompted for credentials, you should really use Windows Authentication if you can.Hope this helps.Regards,Mike WachalSQL ExpressThis posting is provided "AS IS" with no warranties, and confers no rights.Use of included script samples are subject to the terms specified athttp://www.microsoft.com/info/cpyright.htm |
|
|
|
|
|
|
Linked SQL Express tables.