SQL Express - Wizard Issue
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



SQL Express - Wizard IssueExpand / Collapse
Author
Message
Posted 09/11/2007 2:00:25 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 05/02/2008 7:30:29 AM
Posts: 30, Visits: 99
Hi,

I found a little issue that I think is worth informing you about. If I use

MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain to deploy a database on a sql express instance and that instance is the only sql server instance on the computer, the

the ComboBox with the header "Select SQL Server" only shows the computername . If you continue the wizard it will fail to connect to the server. Strange... since I just connected to the server and that worked. After I manually set the sql server to 'COMPUTERNAME\SQLEXPRESS' it worked.

I tried the same with a full sql server version and then it does not seem to matter.

My suggestion would be to always add the Computername + Instancename, even if there is just one sql server instance visible.

Hope you can change that behaviour or tell me if I have done something wrong.

Thanks

Post #11415
Posted 09/11/2007 9:10:07 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
I manually set the sql server to 'COMPUTERNAME\SQLEXPRESS' it worked.

We use SMO (SQL Server Management Objects) to pull all of the available SQL Servers.  This is done by SMO by looking for the Browser Service.  More than likley, the Browser service is not running on the machine in which you have the SQL Server Express installed.  If nothing is returned, then the local machine name is added to the list making an assumption that there may possibly be a SQL instance there.  So this is actually operating as it should.  Start the browser service on the machine where Express is installed and the full name with the SQLEXPRESS should appear.

Post #11417
Posted 09/11/2007 9:26:43 AM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 05/02/2008 7:30:29 AM
Posts: 30, Visits: 99
thats it thanks!
Post #11419
Posted 09/11/2007 10:27:34 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
Glad to hear it
Post #11421
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 4:32pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.062. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.