Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
san79
Starting Member
42 Posts |
 Posted - 2011-10-03 : 00:17:47
|
| hi, i have already posted this question in another forum a week ago, i am reposting it here, my problem is whenever i click a new query screen in smss for sql 2008 r2 express edition, at the bottom it shows disconnected. when i tried to click connect it opens a new connection window but the service shows sql server compact edition not the database service, and that too disabled so i am not able to process any queries or do any thing at all, what should i do. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 01:09:20
|
| go to services.msc and check if sql server service is first running in the server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
san79
Starting Member
42 Posts |
Posted - 2011-10-03 : 01:50:46
|
| @visakh, yes it is running, |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 02:02:30
|
| click on view->object explorer and in the explore window on top click on connect. on connection dialog box see if you're getting database engine option.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
san79
Starting Member
42 Posts |
Posted - 2011-10-12 : 12:09:57
|
| sorry, for such a long delay,i did like that only, still showing same sql compact edition connection |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-12 : 12:17:57
|
| then that means you've only instance of sql server compact edition installed------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
san79
Starting Member
42 Posts |
Posted - 2011-10-13 : 14:14:06
|
| but i am able to create table and it shows database engine sql server express |
|
|
|
|
|
|
sql server 2008 r2 new query screen problem