473,237 Members | 1,089 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,237 software developers and data experts.

I cannot view table content in MS SQL Server Express

I was able to view table content easily before, but after I
reinstalled everything, I cannot find the option to view table content
in MS SQL Server Express. I can define table with no problem. Check
out the screen snapshot below, from which you'll see that the popup
menu frrom right-clicking on the table name does not have the "Open
table" option. What is going on?

http://farm1.static.flickr.com/167/4...39620d0b_o.png

Mar 19 '07 #1
6 13296
It seems you are not connected to an SQL Server Express Edition
server. Instead, you are connected to a SQL Server Compact Edition
server, which is a different thing.

Razvan

Mar 19 '07 #2
On Mar 19, 1:55 am, "Razvan Socol" <rso...@gmail.comwrote:
It seems you are not connected to an SQL Server Express Edition
server. Instead, you are connected to a SQL Server Compact Edition
server, which is a different thing.

Razvan
Yes, yes, you are very right. I also notice that. But how come? I
did download the package from the SQL Server Express website. It is
the one which says "Microsoft SQL Server 2005 Express Edition with
Advanced Services". The installation file has a name SQLEXPR_ADV.EXE,
which is 256M.

Is this the right one? Well, at installation, I did custom install
and made all components available from the local machine.

Pls give me hint, how do I properly install the Express Edition
instead of the compact Edition?

Thanks.

Mar 19 '07 #3
I guess that both SQL Express and SQL Compact are installed now. It's
only a matter of connecting to the desired one. When the "Connect to
Server" dialog appears in Management Studio Express, make sure you
choose "Database Engine" in the "Server type" combo (instead of "SQL
Server Compact Edition").

Razvan

Mar 19 '07 #4
On Mar 19, 12:07 pm, "Razvan Socol" <rso...@gmail.comwrote:
I guess that both SQL Express and SQL Compact are installed now. It's
only a matter of connecting to the desired one. When the "Connect to
Server" dialog appears in Management Studio Express, make sure you
choose "Database Engine" in the "Server type" combo (instead of "SQL
Server Compact Edition").

Razvan
You are right again. Yes, both "Database Engine" and "Sql Server
Compact Edition" show up in the combo. The problem is that I cannot
connect to .\SQLEXPRESS with Database Engine selected, using Windows
Authentication.
Mar 19 '07 #5
[...] I cannot connect to .\SQLEXPRESS with Database Engine selected,
using Windows Authentication.
What error message do you get (below "Cannot connect to .
\SQLEXPRESS") ?
a) "An error has occurred while establishing a connection to the
server [...] Error Locating Server/Instance Specified"
b) "Login failed for user 'COMPUTERNAME\username'"

I guess that a). In this case, go to Start / Programs / SQL Server
2005 / Configuration Tools / SQL Server Configuration Manager. Under
"SQL Server 2005 Services" do you have any entry with the "SQL Server"
as the "Service Type" ?

If yes, try to connect to the instance name specified there (if it's
the default instance, just try to connect to ".").

If no, then the Database Engine seems to be not installed; when you
reinstall SQL Server, make sure that "Data files" and "Shared tools"
under "Database Services" are selected. Then remember what choice you
make in the Instance Name screen.

Razvan

Mar 19 '07 #6
On Mar 19, 3:44 pm, "Razvan Socol" <rso...@gmail.comwrote:
[...] I cannot connect to .\SQLEXPRESS with Database Engine selected,
using Windows Authentication.

What error message do you get (below "Cannot connect to .
\SQLEXPRESS") ?
a) "An error has occurred while establishing a connection to the
server [...] Error Locating Server/Instance Specified"
b) "Login failed for user 'COMPUTERNAME\username'"

I guess that a). In this case, go to Start / Programs / SQL Server
2005 / Configuration Tools / SQL Server Configuration Manager. Under
"SQL Server 2005 Services" do you have any entry with the "SQL Server"
as the "Service Type" ?

If yes, try to connect to the instance name specified there (if it's
the default instance, just try to connect to ".").

If no, then the Database Engine seems to be not installed; when you
reinstall SQL Server, make sure that "Data files" and "Shared tools"
under "Database Services" are selected. Then remember what choice you
make in the Instance Name screen.

Razvan
Hey, Razvan, you really rock!

Exactly that was the problem. I checked the configuration manager.
It looks like that I don't have SQLEXPRESS. The instance name seems
to be MSSQLSERVER.

My computer name is EMACHINEXPPRO and I can connect to the SQL Server
by typing in this computer name as the Database Engine or like you
said, simply put a dot (.) instead.

Connecting to MSSQLSERVER or .\MSSQLSERVER results in error (error
code 53 or error code 87). See the screen snapshot below.

http://farm1.static.flickr.com/175/4...f5145e32_o.png

Good that I can connect to it using my computer name now. Many
thanks.

AL

Mar 20 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Frank Rizzo via SQLMonster.com | last post by:
I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches...
2
by: Belee | last post by:
1. I am using sql server express and visual studio 2003. I have been able to create the connection to the database in server explorer but cannot update table definitions. It gives an error that...
1
by: Jerry Tovar | last post by:
I am using .Net 2003 on a XPPro running IIS. I am unable to view any of my ASPX webforms in a browser unless I modify the .ASPX file and replace Codebehind="employee.aspx.cs" with...
2
by: Tom Hansen | last post by:
I copied an existing web site from a 2000 server to a 2003 server. Added the proper 'Application Extensions' I believe BUT I cannot browse xsd files in the xsd folder (or any other folder). If I...
3
by: collinsd | last post by:
I am trying to connect to a database in SQL Server Express on my PC. The SQLConnection open() method appears to work without generating any exceptions however as soon as I try to do anything to the...
2
by: Rob Pollard | last post by:
Hi All, I'm pretty new to using these technologies so bear with me. I have created a c# app which communicates with sql-server express 2005. When I run an insert on a table via the SqlCommand...
3
by: leonaisse | last post by:
Hi I have a bunch on tables and data in my local SQL Server 2005 Express master DB and I want to export it to a database.mdf within my wwwroot (visual studio) file - how can i do this? Thanks...
0
by: Brad Brening | last post by:
I'm developing a quick site in VWD 2005 and SQL Server Express 2005. I'm using custom forms authentication where my user accounts are stored in a local MDF file attached to the project. I note...
12
by: Light | last post by:
Hi all, I posted this question in the sqlserver.newusers group but I am not getting any response there so I am going to try it on the fine folks here:). I inherited some legacy ASP codes in my...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.