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 |
|
bbxrider
Starting Member
37 Posts |
 Posted - 2011-01-14 : 04:04:42
|
I'm using the studio express, I trust for this question its the same for the sql management studio.I create a sql server login for my sql server instance, per these instructions, http://msdn.microsoft.com/en-us/library/aa337562.aspx, easy enoughthen on a remote pc in the create new (odbc) data source to sql server dialogue, I select the target db (.mdf file), select sql server instance, (remotePcName\sqlExpress), select sql server authentication for how to verify the login id, and enter the login/pswd created above, but get this error  to get as far as I did, I know the server exists, so for some reason its the access denied, so assuming I know how to enter the correct username/pswd  don't know why I'm getting denied access |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bbxrider
Starting Member
37 Posts |
Posted - 2011-01-15 : 03:15:40
|
| thanks for the reply, I guess I had 1/2 the connectivity. In properties/connections I had it allowed for remote server connections, but had to go into server configuration manager, protocols for the db, and enable tcp/ip, then I was finally able to connect. Its odbc for access across my lan. next step will be to setup remote connection via internet. |
 |
|
|
|
|
|
|
|
create sql server login for odbc connection