Simple question for u but difficult for me

Question

Simple question for u but difficult for me

makjain

SSC Enthusiast

Points: 169
More actions
February 6, 2009 at 9:50 pm

#127932

I have created website with database connectivity. Now, i want to put it live and for that i dont know how to provide my database(.mdf file) i.e. on the space which i will purchase to port my website live.
Before providing my database i want to change my windows authentication mode to SQL server authentication mode. I have tried to do the same by following steps:
1.Object Explorer right click -> Properties
2.Security -> Server auth changed from Windows mode to sql server and windows mode
3. Restarted the SQL Server 2005
Now, from where i will provide Username and Password.
I request all of you to provide me solution of my 2 question:
1. How to create .mdf file with my auth i.e. my username and password?
2. How can i change auth from windows to SQL server auth?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

If it's not your own server, for example if it is going to be hosted at GoDaddy or some other host, THEY will give you the user name and password for a database that they will create for you.

From there, you typically script the objects and data and create teh objects in the database.

Usually, if you have a database already set up, you will need to coordinate with the host to restore the database for you, so that they can add the user THEY will create to the database.

so chances are you will not create any MDF file. it's details will come as part of your hosting package.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

makjain SSC Enthusiast Points: 169 More actions · Answer 2

Then too i have 1 question if THEY provide me username and password for sql database then how my web page will work as they have windows authentication.

Will i have to change my connection settings with providers username and password? And

Should i believe that by using their username and password my database will be safe .i.e they wont misuse it.

Lowell SSC Guru Points: 323518 More actions · Answer 3

makjain (2/7/2009)
Then too i have 1 question if THEY provide me username and password for sql database then how my web page will work as they have windows authentication.
Will i have to change my connection settings with providers username and password? And
Should i believe that by using their username and password my database will be safe .i.e they wont misuse it.

yes every host and shared host i ever had or put together for a client used SQL Authentication, Not Windows Authentication. You'll simply change your connection settings in Web.config file or wherever you keep your connection information if it's not .NET to the new server/database name/user/pwd.

That way they can create a login that has access to one and only one database...you'll be able to backup and restore tHAT database, but if you restore a database from a different server as your database, your login would become orphaned a, and you'd have to call your host so they can fix it with sp_change_login

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!