New SQL Express Installation
[173 byte] By [SQLUser2005] at [2008-2-5] 
«« Sql Configuration Problems (Desperately in need of help)
»» type generation from DataContract schema
»» type generation from DataContract schema
If you are using down-level clients through MDAC, you'll need to enable TCP/IP in order to connect to SQL Express, even on the local computer. If you're additionally trying to connect from a remote computer, you'll need to consider turning on SQL Browser and open up your Firewall.
Check out http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx for information about this.
Mike
MikeWachal-MSFT at 2007-9-8 >
Why ODBC out of curiousity?
Why not connect with ADO 2.8? or ADO.net using the new sql native client?
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=myDatabaseName;Data Source=.\Sqlexpress
FergusLogic at 2007-9-8 >
If the server is not the default instance (if you installed it as named instance) you may have to type in the instance name manually.
JimNolandCBI at 2007-9-8 >
SQL Server Hot Topic
- Custom Destination Component Logging - wrote 0 rows
- Can't connect w/Visual Studio 2005
- Package runs fine from BIDS, but same box running from dtexec gives "insufficient product l
- SQL Express Family CTP Now Available
- SQLEVN70.rll error
- Package runs fine from BIDS but dtexec on same box gives "insufficient product level"
- Logon Failure: unknown user name or bad password - using xp_cmdshell or bulk insert
- DataReader Source and ODBC connection to PostgresSQL
SQL Server New Topic
- Calculated fields in a matrix report (RS 2005 )?
- Ragged Right Export trimming off leading spaces in last column
- Error adding a query with Designer
- Gettign multiple values and passing them in expression!
- Using an External Dataset with Reporting Services
- Performance
- Performance
- Cluster Node not running all databases
SQL Server
- SQL Server Integration Services
- Data Mining
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server Tools General
- Transact-SQL
- .NET Framework inside SQL Server
- SQL Server Data Access
- SQL Server SMO/DMO
- SQL Server XML
- SQL Server Replication
- SQL Service Broker
- SQL Server Security
- SQL Server Database Engine
- SQL Server Documentation
- SQL Server Setup & Upgrade
- SQL Server Disaster Recovery and Availability
- SQL Server Notification Services
- SQL Server Compact Edition
- Getting started with SQL Server
- Database Mirroring
- SQL Server Express
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc