can login local

I can login to sql  server (management system) 2008 only with
server name as local
 user name sa and password i set in setup.

It wont work if i use the computer name or computer name with sqlexpress..

Any idea?
does this matter?

jagguyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cheers4beersCommented:
Is this SQL 2008 Enterprise edition, or is it just express edition?  Whether or not it matters depends on what your plans are, and whether or not you plan to access this installation over the network.
0
cheers4beersCommented:
Have you tried using the IP address instead of the computer name?
0
Alpesh PatelAssistant ConsultantCommented:
may be you have changed computer name after installation of SQL server.
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

jagguyAuthor Commented:
i have express ed

I just plan to use this on my PC for testing.
why cant i use the computer name?

>>may be you have changed computer name after installation of SQL server. ") i like this optimism
0
Bhavesh ShahLead AnalysistCommented:
Hi,

exactly what error you getting when you trying to connect.

if error is something like

Error: \\computer_name\instance_name
unable to connect server \\computer_name\instance_name
Server: Msg 67, Level 61, State 1 [Microsoft][ODBC SQL Server Driver] Client unable to establish connection.


then follow below link.

http://support.microsoft.com/kb/265808


- Bhavesh
0
Alpesh PatelAssistant ConsultantCommented:
please use .\sqlexpress as SQL server name rather than full name. It will automatically take the servername
0
jagguyAuthor Commented:
these 2 numbers are different
can you spot the difference? if you can it fixed my problem
R61-L3l2660\SQLEXPRESS
R61-L3I2660\SQLEXPRESS

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bhavesh ShahLead AnalysistCommented:
Hi,

so you did spelling mistake between l & I

=)
0
jagguyAuthor Commented:
i solved it
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.