Link to home
Create AccountLog in
Avatar of johnhardy
johnhardyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

MS SQL data import wizard

I think the Express versions of MS SQL Server do not have the data import wizard available
Does anyone have a way of getting round this on express. Perhaps an addon?
Thanks

John
ASKER CERTIFIED SOLUTION
Avatar of Olaf Doschke
Olaf Doschke
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of johnhardy

ASKER

Thanks I found a developer version on page
http://www.microsoft.com/sqlserver/2008/en/us/try-it.aspx  and downloaded this but I am having problems as the image may demonstrate.
It did open a couple of times but now I cannot get it to open even with Windows Authentication User generated image
Avatar of rajkumarrg
rajkumarrg

Thanks
I tried several of the example given but always receive a error message
eg
ALTER LOGIN xxxx ENABLE;
creates error
Major Error 0x80040E14, Minor Error 25501
> ALTER LOGIN xxxx ENABLE
There was an error parsing the query. [ Token line number = 1,Token line offset = 7,Token in error = LOGIN ]
>>Thanks I found a developer version on page<<
Nope.  You did not download the Developer edition.  That is the Evaluation Edition you downloaded.  It will expire in 180 days.
Thanks for the help
Maybe I am missing something from  Madhu's answer

(a)Expand the SQL Server

(c) Expand Security node

(d) Select the Particular Login (User)

(e) Press right button and select properties of the login

(f) Go to Status table Enble the User

Then try to login
======================

As I cannot login with these options
Server Type= Database Engine
ServerName = machinename\SQLExpress
Authentication = Windows Authentication
Connect brings
Login failed for user 'xxxx\yyyy'. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)
I cannot see how to carrry out the instructions.
These steps (a-e) are for the case you still can login as another SQL Server or Windows account via sql server management studio and then do the steps to enable the other user again.

Have you simply tried stopping and restarting the Server Instance?

Bye, Olaf.
Thanks Olaf
Yes I tried restarting the Server instance (via Services)

I uninstalled and re installed 2008 Express with much the same result.

Cannot connect to xxxxx\SQLEXPRESS.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
As I have had several attempts to get this working and re installed I wondered if the folders containing the versions of mssql should be deleted.
This image may explain
 User generated image
I think I found some answers for my last problem on.
http://social.msdn.microsoft.com/forums/en-us/sqldataaccess/thread/8F52E61E-A888-4A5B-8D56-813F40C3DF2B

Open SQL Server Configuration Manager, choose <your SQL Server instance> protocols on the left and make sure that TCP/IP protocol is enabled (on the right). If you have a named instance (other than MSSQLSERVER and SQLEXPRESS) then double check that SQL Browser service is running as well.
Shows how these questions can expand!

Many thanks for the help