June 6, 2007 at 6:10 am
Hi,
I am new to SQL Server 2005. I tried connecting to my local machine by using my machine name as Server name and then tried running the following query:
SELECT * FROM SYS.Objects. It gives me following error:
Invalid object name 'sys.objects'.
Whereas, if I connect to my local machine using machinename\SQLEXPRESS, then the above mentioned query runs fine.
Why is this difference? What is the difference when I login in these 2 different ways.
Any help would be appreciated.
Thanks in advance.
June 15, 2007 at 3:16 pm
Works for me in SQLEXPRESS and SQL Server 2005.
And this should work in either environment:
select * from sysobjects
Carlos
July 3, 2007 at 2:29 pm
The original question boils down to:
Whereas, if I connect to my local machine using machinename\SQLEXPRESS, then the above mentioned query runs fine.
when you add '\SQLEXPRESS' as part of your connection string. It probably has something to do with your registry settings. Without knowing all the settings, I'd be guessing, but I'd suggest that it could either relate to whether your system is 'standalone' or on a local network, or has something to do with the way you installed your software. Are you a network admin?
July 5, 2007 at 1:51 pm
Have you installed it with a case sensitive collation?
November 1, 2007 at 8:23 am
Hi,
Maybe I could be in some help.
I guess that you didn't pay attention to Instance name of your sql server , and leave it by default value. That value for SQL Server 2000 is a name of your machine.
Default value for sql server 2005 and sql server 2005 express edition is LOCAL/SQLEXPRESS where LOCAL is name of your machine, and SQLEXPRESS is name of instance for your server.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply