September 2, 2008 at 2:17 pm
I get an error "SQL Server does not exist or access denied" if my connection specifies "Data Source=(local)". If I enter the SQL Server name, the connection is successful.
Is there a SQL Server 2005 configuration setting to identify the (local) server?
In this example, I'm editing a .dtsx package.
September 2, 2008 at 2:28 pm
Try localhost without the parentheses.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 2, 2008 at 2:41 pm
localhost without the parentheses has the same result as (local).
September 2, 2008 at 3:51 pm
Is the name [Machine Name]/[Instance Name] ? If it is I don't believe it will respond and local.
September 2, 2008 at 3:56 pm
I do not see anyplace in SSMS where this would be a valid entry. Where/in what facility are you entering the connection setting?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 3, 2008 at 7:57 am
I used SQL Server Business Intelligence Development Studio's Project, Migrate DTS 2000 Package to bring a SQL Server 2000 DTS package over to SQL Server 2005 as a .dtsx file. Then I edited the .dtsx file using Visual Studio. Under Package Explorer I went into the Properties of a connection. Under SQL Server 2000, the connection specified Server: (local). The migrated .dtsx file also has Server: (local) for this connection. I'd like to avoid having to hard-code the server name as this .dtsx package's connection is accessing the local server.
Thanks for your help.
Scott
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply