i really need some help!!!!!!!

well......im from peru....i dont speak english too well.......but...i have the SQL express edition....but when i open it....i gotta to connect to a server.....but i dont have any server.....what do i should put to in "server name" and "authentication"...to star to use the SQL express edition....

well..if there are some grammathical mistakes....sorry...im learnin` english

please answer me
is an emergency!!!!
Jaime

well generally you connect to the local computer\SQLExpress:

(local)\SQLExpress

in regards to authentication, again it depends what type of authentication you set up. Was it Windows/trusted authentication or SQL authentication? if its Windows then you just type in your Windows username followed by the Windows password I believe otherwise its the SQL user account you created

|||well if you can tell me what do i should put in "server name" and "authentication"......i`ll fell better|||

servername AFAIK is usually:

(local)\SQLExpress

as for authentication as stated, depends on the type of authentication you have set up. If its Windows, then enter your username and password you use for Windows login. If its SQL user account, enter the username and password for the SQL user account you created.

|||ahmedilyas...im 17...........im learnin SQL in my university....i dont understand what u said.......but-......how do i know the type of authentication i set up?....can u help me please!!!!!!!|||

try www.connectionstrings.com

Attach a database file on connect to a local SQL Server Express instance:

"Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"
- or -
"Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"
(use |DataDirectory| when your database file resides in the data directory)

Why is the "Database" parameter needed? Answer: If the database was previously attached, SQL Server does not reattach it (it uses the attached database as the default for the connection).

Using "User Instance" on a local SQL Server Express instance:

"Data Source=.\SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|\mydb.mdf;user instance=true;"

The "User Instance" functionality creates a new SQL Server instance on the fly during connect. This works only on a local SQL Server 2005 instance and only when connecting using windows authentication over local named pipes. The purpose is to be able to create a full rights SQL Server instance to a user with limited administrative rights on the computer. To enable the functionality: sp_configure 'user instances enabled','1' (0 to disable)

Using SQL Server 2005 Express? Don't miss the server name syntax: SERVERNAME\SQLEXPRESS (Substitute "SERVERNAME" with the name of the computer)

|||

Hi Jamie,

When you installed SQL Express, you installed the server onto your computer. SQL Express installs by default to something called a named instances, which is just the way we refer to the name of the server. As long as you didn't change anything when you were installing, the name of your SQL Express instance is "SQLEXPRESS". When connecting to SQL Server, you have to specify both the machine name and the instance name, in the format <machine name>\<instance name>. In cases where you are connecting to a SQL Server that is on the same machine that your are logged into, you can replace the <machine name> part with either the word "(local)" or with a period "." as form of short hand. So, in order to connect to the default copy of SQL Express on the computer you are logged into, you would put the following in the Server name text box:

(local)\SQLEXPRESS

Normally, SQL Express uses Windows Authentication, which means that SQL will recognize the same user account that you use when logging onto Windows. If you did not change anything when you installed SQL Express, you should just be able to select Windows Authentication and SQL Express will recognize you without providing any additional user name or password.

Hope this helps,

Mike

|||Hi Michael,

I love your messages! You are excellent

at explaining answers to problems and queries for beginners.

You're the TOP answer provider on the MSDN site in terms of

quality! Thank you!

For your information, this query is probably a popular one due to that

lack of explanation on the SQL video lesson05. He simply assumes

that you can click on the "Connect" button without any explanation

about server name etc - and any beginner will, of course, probably be

opening SQL Server Management for the first time, so therefore would

require this information to continue further.

Like Me!!!

However, following your instructions, I now have another error message

that, according to your information re local connections sounds bizzaar.

I typed in:

(local)SQLEXPRESS

I left "Windows Authentication" as is.

And clicked connect.

The User Name came up with:

YOUR-6202AC0500\user

(which I vaguely recognise as seen somewhere else and appears to

describe my PC.) My directory for "Documents and Settings" is

"user's Documents" (I obviously haven't named my PC) and the owner is

Fran Smith (in case this is relevant) - sorry - as mentioned, beginner.

The error says the following:

Connect to Server

Cannot connect to (localSQLEXPRESS)

Additional Information:

An error has occurred while establishing a connection to the

server. When connecting to SQL server 2005, this failure may be

caused by the fact that under the default settings SQL Server does not

allow remote connections. (provider: Named Pipes Provider,

error: 40 - Could not open a connection to SQL Server)(Microsoft

SQL Server, Error: 53)

There's a little "Show Technical Details" icon at the bottom of the

error message, which I clicked on which provided a "For Help:" http

link. This took me to a page that began "We're sorry.

There's no additional information...". The "Help" icon took me to

the same page.

Why is it seemingly attempting to connect to a remote server when a)

I've specified local and b) it has also even found my PC user

name? What do I do to correct this. I did install it

accepting the defaults provided.

Thank you in advance.

I'm now a little frustrated. I have began the video sequences

(which is a fabulous learning tool because it is explained WHY etc, not

just click here/do this as the written tutorials tend to do); however I

am stuck awaiting answers to all three sequences:

VB - on the

databinding issue: I read the other forums etc, and found the

basic problem regarding the two databases/saving to only the

one/debugging overwrites etc, but I wanted to know how then, do we save

to the actual database, how and when does this occur, if not at that

time? refer VBLesson09.

VWD - userCount

doesn't work for me - either in FireFox (where it doesn't increment) or

in IE7 (where it continues to increment each time a window is

refreshed). refer VWDLesson03

And now, SQL Lesson05.

My other username is BasilTabethaCat. These have been outstanding

for 3 and 2 days respectively, with no reply attempts or answers.

How do I invoke an answer?

I am now stuck as I would rather not continue the learning process

while I have a hole in my understanding (I am a student teacher - so

I'm well informed on the pitfalls of this!)

HELP!!

Cheers,

Fran...

PS I meant the compliment above - your answers in several areas have helped me a lot!