SQL server name and other details
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18134
Printed Date: 30 March 2026 at 9:21pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL server name and other details
Posted By: snoopdujour
Subject: SQL server name and other details
Date Posted: 25 January 2006 at 8:47pm
|
I am a beginner with SQL so please bare with me.
When setting up SQL_server_connection.asp, it asks for the
"SQL Server name, your SQL Server Authentication details, and the name of the empty database you have created for the Forum on the SQL Server."
I put the following in mine, but it isn't working. Can someone let me know what the syntax is.
strSQLServerName = file://\\MyMachineName\sqlexpress - \\MyMachineName\sqlexpressstrSQLDBUserName = "sa"
strSQLDBPassword = ""
strSQLDBName = "forum"
When I launch the MSsql_Server_setup.asp file,
then use the account and password as above (odcb driver installed an working fine) I am unable to login. What am I doing wrong? |
Replies:
Posted By: MadDog
Date Posted: 25 January 2006 at 10:00pm
|
What is this for? ------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: dpyers
Date Posted: 26 January 2006 at 1:34am
|
What error message are you getting? Did you create an empty db before running the server setup? Are you the sa? ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: snoopdujour
Date Posted: 26 January 2006 at 4:53am
|
I have created a new database, and SQL Native client ODBC connection. Do I need to clear out the tables and other items so it is totally empty (blank)?
I am the SA. I am trying to initialize the setup of my forum.
the error I receive is;
Error Connecting to database on SQL Server
Check the following is set up and correct:- SQL Server User Name SQL Server Password Name of the SQL Server Database name set up by you on the server Empty Database set up by you on the SQL Server Check also that you have entered the correct details in the file 'SQL_server_connection.asp' found in the admin directory. Can someone give me an example of the syntax I need for this connection? Thank you.
|
Posted By: MadDog
Date Posted: 26 January 2006 at 6:03am
|
1) You need to post in the Support forum
2) Make sure you read the documentation that came with the forum. ------------- http://www.iportalx.net" rel="nofollow">
|
Posted By: huwnet
Date Posted: 26 January 2006 at 4:31pm
|
I am not sure but I think this line: strSQLServerName = file://%5c%5cmymachinename%5csqlexpress/ - \\MyMachineName\sqlexpress is wrong. Usually this is an IP address but I might be wrong. |
Posted By: michael
Date Posted: 26 January 2006 at 6:38pm
|
If you are using the sqlexpress instance, you need to use
strSQLServerName = "computername\SQLExpress"
don't use UNC identifiers \\
Are you sure that SQL Express was installed in mixed mode? meaning being able to login with sa using sqlcmd? I think by default it installs in Windows Auth only. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: snoopdujour
Date Posted: 26 January 2006 at 7:37pm
|
Sorry for incorect info in my earlier posts. This SQLExpress installation is in Mixed mode. I have also checked the Security\logins for the userID and password. I checked to make sure the user has create/modify rights on the database. I have edited the SQL_server_connection.asp file with the following strSQLServerName = "machineID\SQLExpress" strSQLDBPassword = "Userpass"
strSQLDBName = "forum" I am still getting the error connecting to the SQL database.
Have I done everything correct, or am I being a noob and forgot something?
Thanks
|
Posted By: michael
Date Posted: 26 January 2006 at 9:23pm
|
In this instance you cannot use a domain account, you would have to change the connection string to use Integrated Security, add the IUSR_Machinename account to the database etc.
Try the following from a command prompt:
sqlcmd -Scomputername\sqlexpress -dforum -Uusername -Pyourpassword This should bring you to a 1> prompt or at least tell you whats wrong. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: the boss
Date Posted: 28 January 2006 at 3:14pm
|
u canr use file://\\servername\daabasename - \\servername\daabasename ..it is wrong
u specify only the server name or IP address..usually best to do it with IP address.. less headache ------------- http://www.web2messenger.com/theboss"> 
|