Hello all,
Thank you for viewing this query. My query is as follows:
I have a SQL Server which was replicated from Server 1 to Server 2(as we want the website to be moved on to the 2nd server which runs on windows 2000). So, now in the second server the replicated SQL server is available. I have moved the webpages to the new server and am trying to create a DNS.
While i try to create the system DNS, it asks me for the dns name and server name, now which server must i choose? been given 3 options:
local, server 1, server 2.
must i choose local??
i tried choosing local (as the sql server is already in the server 2) and clicked next, and chose
"with sql server authetication using a login and password entered by user"
and entered the same login and password that was used for dsn in server 1 ......and i get the error
connection failed, sql state 25000
SQL Server Error : 18456
Login failed for the user "the login name i used"
(i had also changed the security authetication from "windows only" to "windows and sql server" . well, was asked to stop and resatrt sql server for this ...and i reight clicked on sql server (in enterprise manager to stop and start...is that all i must do for that?))
what must i do to be able to create dns successfully? are there anything else i must take into consideration? please help.
thanks
regards,
karthik
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks for you comments.
programming_gal, I had already clicked on SQL Server & Windows for security authentication.
Luani, how do i transfer/open the login/users from server 1 to sever 2?
I am sorry, I am quite new to SQL server and replication of SQL server was done by someone else. how can i check if teh users\login name have been tranferred aswell? if not...how can i do so.
Please advice.
Thank you.
regards,
karthik.
hello all,
the problem is solved....i was using a wrong user login. :( and wasted hours to figure out the problem.
anyways, i set up a dsn for sql on the replicated sever and tried accessing the webpage....
while accessing the .asp pages i get this error:
MS VBScript runtime error(0x800A01B6)
Object doesnt support this property or method: 'localMatch'
abc/include/include1.inc
similarly another asp page which sends mail....works fine on server 1 but on server 2 says
permission denied..
i am not sure if its problem with iis server .....as i had tested another simple asp page which i had created and it works.
the same page works just fine in server 1 from which i had replicated.
please advice as to whats going wrong?
thanks
regards,
karthik
Business Accounts
Answer for Membership
by: Programming_GalPosted on 2003-06-17 at 00:35:40ID: 8738342
You have SQL Server set up to use Windows Authentication. Unless you are using Windows Authentication exclusively throughout your web site, you should have SQL Server set up to authenticate using mixed mode - this allows support for Windows Authentication AND passing credentials via clear text (e.g. a connection string from ASP). To make sure SQL Server is set up to be in mixed mode:
Open Enterprise Manager;
Expand a server group;
Right-click a server, and click Properties;
Click the Security tab;
Under Authentication, click SQL Server and Windows.
Now, make sure you have a valid user set up to access your tables, views and procedures
http://www.aspfaq.com/show