var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
HELP! SQL 2000 remote access
Hi there - completely stumped with this one.
Have SQL 2000 running on Win 2000.
However, when I set up a SQL db and user /password. they can't login.
The error is "not a trusted user, access denied"
I can't seem to change from Windows authentication to SQL authentication in SQL server properties.
It always defaults back to windows authentication.
I've tried lots of things , re client network access (TCP) , and SQL settings and logins etc etc etc..
Am I doing the right things? Any ideas?
Thanks in advance
Use your sql enterprise manager
right click on the server name
click security tab
click sql server and windows authentication
then start and stop the sql server (right click server name and click stop and then start)
No, I think his problem is that the SQL Authentication option is grayed out. I had that problem too, but I forget how I fix it. I think I just kept searching Google about it and something made it magically allow me to.
Keep poking around and Google is your friend.
Thanks guys - yes, the option in Enterprise Manager is greyed out.
Qgyen, please let me know if you remember how you resolved this
Have spent a long time on Google already
Thanks in advance
Another way to change the security mode after installation is to stop SQL Server and set the following registry key
to 2 for Mixed Mode or 1 for integrated.
Mike @ Xiolink.com
Advanced Managed Microsoft Hosting
"Your data... always within reach"
Its grayed out because you do not have the 'sa' privilege. You woould need to sign on as 'sa'
I'm pretty sure nobody would give you that on a website.
You will need the host to change the registry since you better not have that ability or have them go into enterprise manager as I indicated.