Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipcip
Starting Member
3 Posts |
 Posted - 2006-01-30 : 20:08:20
|
| hi,still now i'have my mssql db hosted in an hosting company.now i'm trasfering it in a web farm so i need to create my dbs by my self.i've already installed mssql but i'm some questions:I noticed that in visual studio 2005 i can create my sql database and place them in a special folder called app_data, what is this new?i think it is imposible because sql server is a serverdb and not a file based db like access!Should i use this feature or should i create my db with Sql enterprise Manager?then: to allow boot clients and web connections with this db how/what i have to setup enterprise Manager?I hope you can help memany thanks Robert |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2006-02-01 : 15:49:06
|
I need more information to assist. First, are you trying to create databases on your network that the web servers will access? Yes, you will need to create databases in SQL Server. Just putting them into a directory will not do anything. Second, Is your database SQL 2000 or SQL 2005? Is it MSDE or SQL Express?I don't understand the question quote:
then: to allow boot clients and web connections with this db how/what i have to setup enterprise Manager?
Can you break that down for us?Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
 |
|
|
cipcip
Starting Member
3 Posts |
Posted - 2006-02-01 : 18:34:52
|
quote:
allow boot clients and web connections with this db how/what i have to setup enterprise Manager?
i need to make a client who is able to connect my sql2005 database on the server but i don't know how to allow iti've tried to use a standard connection string in the client,(the same i use for website connections to the db) but doesn't work.so the question is which string connection i have to use to link my remote db from a client?, what i have to setup in my sql server? for example should i enable tcp/ip connections?what else? |
|
|
|
|
|
|
hosting to hausing