June 14, 2009 at 2:36 pm
I'm in really bad shape.
On my windows server 2003 (which was 32 bit at the time I beleive) I had installed the Developer Edition 2005.
The server is now 64 bit, so I installed SQL Server 2005 and installed it again with SQL Server Developer Edition 2005.
I installed using a WIndows Administratror ID. WIth the Administrator ID, I am able to open up SSMS and connect to my default instance.
When I logon with a PowerUser ID to the same machine and try connect to SSMS, it just hangs.
The strange thing is when I move that logon to the Windows Administrator Group, SSMS works fine but outside the Administratro group, it doesn't work. I am able to connect to the database engine with the Power User through sqlcmd but not through SSMS.
What is it that the Administrator ID is accessing to allow me to connect successfuly to the Instance via SSMS that isn't being allowed using a Power User ID?
Also, what is the difference between sqlweb.exe and sqlweb.exe x32? Does this mean that there are some remenants of the 32 bit version still on the Windows Server that I haven't gotten rid of?
The machine also has 2 Program File directory under the C:.
One is Program File and the other Program File (x86) and for some reason, when I did the install, the folder Microsot SQL Server was created on both.
Please help
June 14, 2009 at 3:53 pm
Also, what is the difference between sqlweb.exe and sqlweb.exe x32? Does this mean that there are some remenants of the 32 bit version still on the Windows Server that I haven't gotten rid of?
No x64 by default installs both x86 and x64 components because not all programs can run x64 so you can use x86 for 32bit programs. You need to make sure your Win2003 is SP2 or you cannot connect to anything Office because without SP2 there is no x86 ODBC that will let you connect to Office both JET and ACE drivers.
The the account issue you may have to make SQL Server both Windows and SQL authentication so you can add login and database account for your power user.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply