| Author |
 Topic Search  Topic Options
|
dddsoftware 
Newbie
Joined: 12 January 2006
Location: Netherlands
Status: Offline
Points: 3
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: How to configure msSQL_server_setup.asp
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  |
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
|
|
dddsoftware
Newbie
Joined: 12 January 2006
Location: Netherlands
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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!  |
|
snoopdujour
Newbie
Joined: 25 January 2006
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
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 = \\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? |
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
kasmithnh
Newbie
Joined: 31 January 2006
Location: United States
Status: Offline
Points: 1
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 January 2006 at 6:33pm |
|
I'm stuck also... Is there a specific format?
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
dddsoftware
Newbie
Joined: 12 January 2006
Location: Netherlands
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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
|
|
