Re: ADP2007/SQLServerExpress RIP

SERVERNAME\SQLEXPRESS is what you need to use for SQL Express.

RIGHT?





On Mar 17, 5:57 am, "Burton Roberts" <FlagR...@xxxxxxxxxxxxxxxx>
wrote:
I am giving up. I figured maybe there was a bug in the Data Link dialog in
finding a named instance of Express, and so I tried uninstalling and
reinstalling in order to create a default instance, but it keeps creating
the named instance. I even went so far as reinstalling VISTA before I
reinstallled SQL Server Express, and it still creates the named instance
without my prompting.

Anyway I can't create an ADP linked to my sql server file. I can create
links to tables from an accdb file, however, which according to some experts
is the prefered way to use Access with Sql Server.

I'm a bit OCD, so this is bothering me that I don't have the ADP option
anymore, and nobody from Microsoft made an effort to help. Being an MSDN
Universal subscriber, I am dissappointed.


.

Relevant Pages

  • Re: Migrating DTS Packages on SQL 2000 to SSIS on 2005
    ... You can install a named instance of SQL Server 2005 on the same box as SQL ... server as SSIS does not support named instances. ...
    (microsoft.public.sqlserver.dts)
  • Re: Do SqlServer 2000 & SqlServer 2005 co-exist
    ... I understand that you can connect to SQL 2000 named instance on the local ... to an instance of SQL Server 2000 or of SQL Server 7.0 that was installed ... Select TCPIP, and click Properties, and set the port of the instance to ...
    (microsoft.public.sqlserver.setup)
  • Re: cluster connection issue
    ... Named instance uses a dynamic port. ... your new named instance and make sure that this port is open on the FW. ... SQL Browser service is running on both nodes on the failover cluster. ... SQL Server does not exist or access denied" ...
    (microsoft.public.sqlserver.clustering)
  • Re: AS2005: Cant access named instance / sqlbrowser issue...
    ... This posting is provided "AS IS" with no warranties, ... cannot connect to the named instance. ... You cannot start SQL Server Browser service? ...
    (microsoft.public.sqlserver.olap)
  • Re: SSMS 2008 Registered Server problem
    ... I also tried uninstalling and reinstalling older versions of .net, ... I've repaired the sql server installation, ... Not that this really seems to be a bug with SSMS, ...
    (microsoft.public.sqlserver.tools)