A little connection chaos.

Hi Mike,

Me again, in trouble as usual.

Finally got my application finished, and want to have the database on a server, with the ability to access it from the Internet, or from our internal domain. Had some help setting up the server wirth Small Business Server 2003, after which everything went pear shaped. My helper renamed my PC, on which I'd been using SqlExpress as a local server. With that, in Visual Studio I was only able to access my database by changing the connection string to a User Instance.

I now have SqlExpress installed on the SBS Server 2003, and installed a copy of my database there. I have a situation that logged on as a User on my PC, I cannot connect to my database which is on the server, either in Management Studio, or in Visual Studio. I can 'see' the server instance, but cannot connect. I think it's something to do with permissions, but dont know how to fix this. I've had two MS Sql error messages one No. 4060 and the other No 916.

If I log on as administrator, things change. I can connect to the server database in Management Studio, and open all my tables, however, if I try to do the same in Visual Studio, this fails. Initially I couldnt even connect to a User Instance, but on the last try I was able to. I've read your FAQs and Blogs, but haven't progressed much.

My big problem is in wanting to deploy my application, I need to establish the correct connection strings for my settings. Since I have to manually change all my Crystal Reports connection strings as well, I'd prefer to only have to do this once.

I know this isn't much concrete info on which to work, but hopefully it will give us a start.

As User logon the two sqlservr.exe Processes you mention where running. As an administrator logon, there are two sqlservr.exe processes running, one as NETWORK SERVICE the other as SYSTEM. if that is any help.

John

hi John

Tailor wrote:

..

I now have SqlExpress installed on the SBS Server 2003, and installed a copy of my database there. I have a situation that logged on as a User on my PC, I cannot connect to my database which is on the server, either in Management Studio, or in Visual Studio. I can 'see' the server instance, but cannot connect. I think it's something to do with permissions, but dont know how to fix this. I've had two MS Sql error messages one No. 4060 and the other No 916.

If I log on as administrator, things change. I can connect to the server database in Management Studio, and open all my tables, however, if I try to do the same in Visual Studio, this fails. Initially I couldnt even connect to a User Instance, but on the last try I was able to. I've read your FAQs and Blogs, but haven't progressed much.

...

please verify an actual Login (individual or at group granularity) exists on the SBS installed instance for your remote credentials...

that's meaning, your limited user has probably not been granted authentication rights to the instance..

regards

|||

Hi Andrea,

My apologies for the delay in replying, as I've been away for about a week.

I'm sure you are correct, so will see if I can sort it out, although it's my first experience of SBS.

Thanks

John