August 24, 2007 at 4:43 am
I am working remotely from my servers and have therefore installed a version of SQL Express (default instance) on my local machine, with the Management studio from Express as well.
Due to the way my institution works I haven't got admin rights as 'normal' user, so had to run all installs logged in as local administrator.
While logged in as local admin I can run the management studio and connect to the local instance (SQLEXPRESS), but if I log in as 'me' I can run management studio, but it won't connect. Not only that, it hangs and even cancel won't work, I have to kill the program through Task Manager. If I select to open Management Studio with 'Run As...' and use the admin log-in and password, then the connection works.
I have set my account up as user on the database with all the access rights I can tick. I have opened the Firewall for TCP/IP, named pipes and Shared Memory, as well as enabling the SQL Browser.
Have been fighting with this for the last two days, and have run out of ideas, any thoughts more than welcome.
Thanks, Kris
August 24, 2007 at 9:26 am
Kris,
Is your Local Machine a Windows Vista and you have SP2 for SQL Server?
During SP2 installation on the servers it asked me to run some tool for Windows Vista to give Windows logins rights in SQL Server. I also can access this tool if opening SQL Server Surface Area Configuration tool and clicking on the link Add new Administrator. The window that opens is called SQL Server 2005 User provisioning Tool for Vista
Regards,Yelena Varsha
August 24, 2007 at 9:42 am
Sorry, should of course have said that I run Windows XP with all available updates, the version of SQL that I am using is the Advanced Version of Express as downloaded from Microsoft.com a fwe weeks ago.
Thanks,
Kris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply