How to configure msSQL_server_setup.asp
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=17917
Printed Date: 13 April 2026 at 4:32pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: How to configure msSQL_server_setup.asp
Posted By: dddsoftware
Subject: How to configure msSQL_server_setup.asp
Date Posted: 13 January 2006 at 3:22pm
|
I'm a newbie @forum setup.
One simple question, what variable put i where in the msSQL_server_setup.asp file?
my connection string: FILEDSN=domain_org.dsn
SQL server IP: 12.345.36.789
SQL username: AQLUser_domain.org
login database: admin
passw: letmein
thanxz 4future support
greetz, peter
 |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 13 January 2006 at 3:39pm
|
Before trying to workout the problem as I don't completly understand your post, do you have already setup by your hosting company a MS SQL Server database? If you do have an MS SQL Server database already setup by your hosting comapny, do you have the server and login details from your host? ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: dddsoftware
Date Posted: 13 January 2006 at 6:37pm
|
everything is setup en uploaded to server.
MS SQL server database is setup bij hostingprovider and i have login details.
thanxz 4fast reply!
 |
Posted By: snoopdujour
Date Posted: 26 January 2006 at 4:35pm
|
I am having the same difficulty.
I don't understand what I am supposed to put in the connection string.
I am a beginner with SQL so please bare with me.
I put the following in mine, but it isn't working. Can someone let me know what the syntax is. (I can't find any examples in the Documentation)
strSQLServerName = file://MyMachineName/sqlexpress - \\MyMachineName\sqlexpress strSQLDBUserName = "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? |
Posted By: WebWiz-Bruce
Date Posted: 26 January 2006 at 5:42pm
|
Try:- localhost\SQLExpress If the installation is running on the same server. Also make sure you setup SQL Express to run in 'moxed mode' (option when installing), as this will allow TCP/IP connections to the SQL Server ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: kasmithnh
Date Posted: 31 January 2006 at 6:33pm
| I'm stuck also... Is there a specific format? |
Posted By: michael
Date Posted: 31 January 2006 at 9:45pm
|
strSQLServerName - should be the IP Address or Server Name provided by your hosting provider. Do not use a path or anything like that, just the DNS Name or the IP Address. If you are running a Named Instance i.e. SQLExpress you need to add this Instance Name by a backslash. So either servername or servername\instancename
sqlSQLDBUSername should be provided by your hosting company also. If you are running locally it can be SA, otherwise it is usually a loginname like domain.com or some other username provided. sqlSQLDBPassword is the password provided by the hosting company. If you are using sa I would NEVER leave it blank. strSQLDBNAme should be the database assigned to you or you created. So if you run local use a command like create database myforums If you are hosting, they usually assign a db name to you. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: dddsoftware
Date Posted: 31 January 2006 at 10:04pm
|
Thanxz4reply
i will try these settings a.s.a.p., for the time being i use another
greetz,
peter
|