Nevermind, I figured this out.
Instead of using %MACHINENAME%\MSSQLSERVER,1433 USE
..\MSSQLSERVER,1433
It works fine.
"Phil" wrote:
[Quoted Text] > I used the BCM 2007 Database tool to create a new database using the > MSSQLSERVER named instance and I shared the database. I am unable to connect > to the database on the local machine but don't have any problem connecting to > the database from another computer. I am using the follow > %MACHINENAME%\MSSQLSERVER,1433 string to connect and it works fine except on > the local machine. > > ---------------- > This post is a suggestion for Microsoft, and Microsoft responds to the > suggestions with the most votes. To vote for this suggestion, click the "I > Agree" button in the message pane. If you do not see the button, follow this > link to open the suggestion in the Microsoft Web-based Newsreader and then > click "I Agree" in the message pane. > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=ab277aa7-c2b6-4622-9179-880965483ec4&dg=microsoft.public.outlook.bcm |