web site made in web dev
db all ok locally
got server at local ip......
need to upload script files to server...
got microsoft publishing wizard all working and database all scripted out.
server consul looks like horrible unix outfit....virtuozzo
question is now what?
ip says use enterprise manager to publish to server.....is that the old
version of management studio express, which i have
You can always download the new version of SQl Management Studio for free. For publishing you need to register it with the DNS and then put either the IP or the servername in the connection string.
|||I have got ssmse already
can you expand a little on this "For publishing you need to register it with the DNS "
|||If you are using an IP address or a server name thatshould be resolved through DNS or over the Internet, you'll want to make sure that TCP/IP is enabled. Go to Start / Programs / Microsoft SQL Server, open the Client Network Utility, and on the General tab, make sure TCP/IP is at the top of the list on the right hand side.
If you are trying to connect to a named instance, you can use the following format:
If you are running SQL Server or MSDE on the same machine as your ASP pages, you are probably tempted to use the hostname "localhost." This doesn't always work, due to different configuration issues, so try (local), 127.0.0.1, the actual host name, or simply a period (".").
|||
yes.. why dont I run both the asp pages and sql server on the
server together...sounds much cleaner. great idea
I,ll give it a try.
Thanks so much for your help naturehermit
yes.. why dont I run both the asp pages and sql server on the
server together...sounds much cleaner. great idea
I,ll give it a try.
Thanks so much for your help naturehermit
Thanks and all the best
(If you have got a large website, running sql server and code on same machine will create performance issues)
|||oooh
right ..maybe not then...i think i can see where
you are coming from.
|||
However I have run many test with 100 or so cuncurrent users where SQL Enterprise and Asp.net are both sitting on a win2k3 Enterprise Machine with 4 Gig RAM, havent found any issue at all.
|||So if I was running a server with seperate asp.net pages ...no problem.
This is all new to me and trying to get sorted what road
to go down is the hardest bit.
Got any help on publishing scripts to a server.
I don,t know if I should be uploading sql server 2005 to the server or just
the .mdf
|||Hi there,
I shall try to explain this,
With publishing scripts if you mean the code, then in visual studio there is a publish website option, from Build. If you mean something different please specify.
sql server 2005 is a server itself that runs on top of windows 2003 and hence if you havent given your sql server a different name it should be the name of your 2003, If you have DNS enabled and have got a domain, it should already be configured for you.
If you want somebody to host the db for you, then you can supply them the .mdf files so that they can re-create the table in their sql host for you, however in that case you will need to modify your connectionstring to theirs.
so for e.g. curently say you are using server =192.168.1.1 and they may have a server with ip 2.3.2.1 or say sqlserver(if mapped to dns)
then you will simply use
server =sqlserver or server =2.3.2.1 in your connection string.
Hope that helps
|||
If you want somebody to host the db for you, then you can supply them the .mdf files so that they can re-create the table in their sql host for you, however in that case you will need to modify your connectionstring to theirs.
Is that all.
You see after reading this article I decided that I should have to build scripts..DDL to upload to a "server"
http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
rather than just upload .mdf to my host......I think I have over cooked this some what
|||Well that article is to make life easier for people and for people with stored procedures and other stuff. Generally .mdf is enough to create the database. But as pointed out in that article most providers do not know what they are doing and hence it creates a lot of problems to iron out these installation issues. Do not upload but supply them .mdf files and ask them to create the db for you, and they will give you the server name to modify in your connection string.
|||naturehermit you are truly a star of mine.
thanks for all your help today...I owe you.
And I hope this post may help others who get to this greyer area
regards Richard
|||Hey Richard,
Thanks for your compliments but I am just an ordinary folk. Please feel free to ask if you get stuck. Also please mark all posts that helped you.
Regards
No comments:
Post a Comment