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 |
|
raykon
Starting Member
1 Post |
 Posted - 2009-03-09 : 12:28:14
|
Hello,I would like to access the tables inside SQL database from a networked computer. The main computer on which the server is installed is called MASTERPC.The following is the connection string used locally on the PC. When I use the same string on any of the other PC connected to the network it produced error message. <odc:ConnectionString>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Data Source=MASTERPC\MONSOON;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MASTERPC;Use Encryption for Data=False;Tag with column collation when possible=False;Initial Catalog=Monsoon</odc:ConnectionString> To be specific I get the following error when I drop the connection file in ExcelSQLSTATE: '42000'SQL Server Error: 18456Login failed for user 'MASTERPC\Guest'.I appreciate help. |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2009-03-09 : 17:42:33
|
| Looks like the PC you're trying to connect from is logged in with the Guest account. You need to login to the PC as a user that has been granted access in SQL Server.Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
|
|
|
cannot access SQL server tables from network PC