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 |
|
MReed98643
Starting Member
2 Posts |
 Posted - 2005-09-27 : 05:34:29
|
Hello -- Please excuse my extreme newbieness -- trying to get up to speed fast on SQL Server Express for work. I've been able to set up the software, create a database, and access it with no problems on my local computer, but I need to make the database available to other computers in my workgroup. I followed instructions -- enabled TCP/IP and Named Pipes and turned on SQL Server Browser, and I was actually able to manipulate one system database (the "master" database) from another computer but not any other databases, not even the other system databases. I can connect to any of the databases with the SQLCMD commands, but if I try to do any SELECT commands (other than in "master") I get an error: "SELECT permission denied on object '[MyTable]', database '[MyDatabase]', schema 'dbo'". I was only able to get into "master" after adding "guest" as a user, but adding this user to the other databases has no effect. One interesting thing: When I used the sp_table_privileges command on each database, all but "master" showed all privileges being granted to and from "dbo", but "master" didn't show anything being granted to or from anybody. Does anyone know what could be going on here? Am I missing something obvious? Thanks for any and all help!  |
|
|
MReed98643
Starting Member
2 Posts |
Posted - 2005-09-27 : 13:15:30
|
| I've worked on this some more, and I'm now able to create a table on my local computer that I can get into and manipulate from another computer on my network. It may not be the most satisfactory solution, but it works for a start. I used "create table [DBName].guest.[TableName]()" instead of just "create table [TableName]()". My remote computer logs on as "guest", apparently. I get full access to this table from my local computer too, as long as I remember to refer to it as "guest.[TableName]". Any other suggestions are appreciated. Thanks -- Marty |
 |
|
|
|
|
|
|
|
Sharing SQL Server Express among workgroup