Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Windows 7		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mr Pink
Junior Member

United Kingdom
387 Posts
Posted - 08 April 2010 :  13:29:59  Show Profile  Visit Mr Pink's Homepage  Send Mr Pink an AOL message
I have just installed windows 7 Home Premium on my pc

My forum uses MS SQL database and I need to download the data.

With XP and Vista this was easy. Not with windows 7

I have installed DTSWizard and SQL Server Management Studio Express (2005) but I have "No Server Connection" on my pc. What do I do next?
Martin
Leyland Forum Leyland Lancashire UK

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 10 April 2010 :  06:40:08  Show Profile  Send ruirib a Yahoo! Message
I would say make sure the Windows Firewall is not blocking it.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Mr Pink
Junior Member

United Kingdom
387 Posts
Posted - 11 April 2010 :  10:06:44  Show Profile  Visit Mr Pink's Homepage  Send Mr Pink an AOL message
The problem is that I can't even create a database on my pc because it won't act as a server. How do I turn on the server in Win 7?
Martin
Leyland Forum Leyland Lancashire UK
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 11 April 2010 :  10:10:39  Show Profile  Send ruirib a Yahoo! Message
Likely the server is running, you just can't communicate with it because of the windows firewall.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Mr Pink
Junior Member

United Kingdom
387 Posts
Posted - 11 April 2010 :  10:36:05  Show Profile  Visit Mr Pink's Homepage  Send Mr Pink an AOL message
On windows XP there was a server icon in the bottom right hand corner of the screen, there isn't a server icon on my windows 7 machine.

I turned off windows firewall but that makes no difference.

Also when I go into the import and export wizard there is no server name to select, it is blank.
Martin
Leyland Forum Leyland Lancashire UK
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 11 April 2010 :  11:01:56  Show Profile  Send ruirib a Yahoo! Message
There is no server icon on Windows 7, as there was none on Vista. You need to check running services, using Administrative Tools, to make sure the services for SQL Server are running.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Mr Pink
Junior Member

United Kingdom
387 Posts
Posted - 11 April 2010 :  15:09:38  Show Profile  Visit Mr Pink's Homepage  Send Mr Pink an AOL message
I've fixed the problem.

I had to uninstall SQL Server Management Studio and re install it.

This link helped.

http://msdn.microsoft.com/en-us/library/bb500441.aspx
Martin
Leyland Forum Leyland Lancashire UK
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07