June 27, 2007 at 2:48 pm
Hi
I can login into the SQL Server locally under mixed mode. But i am not able to login into the server remotely. I can logino the remotely only if i have sysadmin rights on the box...But i am not supposed to be sysadmin on the box. i have the access for some of the databases under dbo role. .......
There is no problem with ports also.Its already open. Remote connections are marked as checked for both TCP/IP.
The problem is if i have sysadmin role then only i am able to login remotely into the sql server under mixed mode. It shoud not the case in general . I am not supposed to be sysadmin role on the SQL Server box. I was just wondering if any one can reslove the problem it would be great appriciate for me
June 28, 2007 at 2:05 am
Are you running with SQL Server 2005 Express Edition. I hope this issues is with that edition and few mant threads are already running in this forum for the same.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 11:13 pm
no iam using enterprise edition..is there anything with set SPN.....?
July 3, 2007 at 5:30 am
Wat's the default db for the login? does the login have necessary privilege on default db?
Regards..Vidhya Sagar
SQL-Articles
July 5, 2007 at 5:26 pm
I developed on a remote SQL Server with DBO permissions for the last few months, I have browser service enabled in the surface area configuration tool, I also have allow remote and local and I also enabled both TCP/IP and Named Pipes, the login was with IP address which changed several times without connection issues. I am an admin in my laptop but on the remote server it was DBO without connection issues on the database engine, Reporting services however will drop the login info serveral times a day and I just know adding that info is part of a normal day. Hope this helps.
Kind regards,
Gift Peddie
July 10, 2007 at 3:59 am
i will just summarise it point wise
1. have browser services enabled and running
2. have local and remote tcp/named pipes enabled
3. have named pipes protocol enabled
this will prevent most connection problems.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply