[HELP] Website on 1 PC SQL - Connection fails.

[TheJAZZman]

I actually am running 2 different SQL servers on 2 separate PC's.

The SQL servers can see one another across the network, np - connect etc. However, the skyteam website install program does not recognize 1 of these servers. It works GREAT with the SQL on the same machine (localhost) - but it doesn't want to connect to the PC across the network.

Is it possible with any MU Website to do this?

Is there some special character I'm missing when trying to connect? I've tried \\servername, IPaddress, IPaddress\\servername, and x:\servername (<--where x is a shared drive to the PC with the server, I know it shouldn't work but I was desperate^^)

I've looked through the forum's for hours, and am just not having any luck.

Q: Does anyone know of ANY website program that will allow setup without the SQL server being on the same machine?
or a special character or way to type the other SQL server name in that I may be missing?

Thank you in advance for any suggestions and help.

[MentaL]

[TheJAZZman]

I'm looking through several other SQL forums as well, and I'm thinking maybe:

because I have the SQL server I need to access on a PC not internet accessible, I need to make sure the internal port is forwarded within my other SQL server (on my (local) server) and use replication.

I have no idea if this is going to do the trick, lol, but looks good - so if anyone has a clue how to use this sort of publication and distribution to work with the website....please let me know^^

Otherwise, when I figure it all out I'll make another post so others can see too.

I still don't really feel close to resolving this, so really, any idea's at all would be cool!

Thanks!

[TheJAZZman]

I've been unsuccessful so far - but this is my weekend project...again^^ So if anyone has even a vague idea, i'd be willing to give it a try. Thanks!

[kirka121]

make sure ur 1433 is forwarded on the router. if you are not using the default port for MSSQL, forward the one u r using. make sure that ur firewall is allowing mssql connection from 1 pv to other and ONLY this way, not from 1 pc to all cause tehn u have a mssql opened and its easy to hack you.

[TheJAZZman]

Thank you for reply - 1433 was the default port, and setup correctly on internal network.

[PC1 SQL Server] <------> [PC2 SQL Server]
----Connects - views and changes Data from within either Server Enterprise Manager.

[PC2 SQL Server] <------> [PC2 PHP Website] Connects - works great

[PC1 SQL Server] <------> [PC2 PHP Website] does not connect or work

After several fruitless attempts at connection, I've decided to go with replication.

I now have ;
[PC1 SQL Server = Distributer] <-----> [PC2 SQL Server = Subscriber] Publishing to a new database on (local)

**My theory is, the php scripts won't allow connectivity across intranet -- they need to connect to (localhost) only -- meaning, I could connect to a SQL server using a different IP address (WAN) than my own, as long as it was on the same machine that IP was forwarded to, and not another somewhere else on its own network. It actually kind of makes sense.

Anyway, I just finished setting it all up, and have 1 problem left -- authorization.

It's not writing the data to my locally shared folder because of a user authorization^^ HAHAHA It so figures, no big deal....I think^^ -- I believe by setting up a user on my local system to match the user / pw on that system, it should be no problem...wish me luck, and leave any suggestions or thoughts you might have.

If it works...I can have multiple server types on the same network, all managed under one website!! That would be good, since I already have a 25x and a 500x -- I don't dare open my 5000x until I fix this^^

I do promise this to all who are reading the post --- WHEN I figure this out, I will share it in a guide. I'm not great at them, but I'll do my best to give the information so others can do the same if they wish -- as well as give full credit to all those who are able to help!

Thanks again for any suggestions!

[TheJAZZman]

Just an update for all those interested....

Replication will work! I have successfully created and tested registration -- there's still some work to make it all function with the web site....I will post a guide, as promised, when I'm finished.

If anyone has already done this and wants to jump in and give me some pointers -- that would be fine too!!! ^^ for now, I have to hold an event, and then I'm back on this "project!"

[winiciusbz]

link download sql 2000 fre pls

[-=ExcLiKeRs=-]

ei... can i ask??

what is the use of SQL Server??

why it is needed in creating mu??

and also what is database??

thanks