SQL server ERROR?

Hello I've finally finished my project in JAVA and now out of boredom I try to learn vb.net along with SQL server 2005..

The problem is:

1. I open the SQL server management studio express..
2. A dialog box open.. and I set the server name.. "I Didn't typed it.." it was the only choice ..

3. Everytime I click the Connect I recieve the error below..

if the image not working.. see attachment..

I never used SQL server.. and I don't even know where to make the database there.. I read tutorials.. but it's all typing things.. I mean.. how will I create a big RDBMS with just typing codes to create tables and such..

1. is there a GUI that will let you design databases like access.. and vb6 database manager?

2. And forgive me for being such a n00b.. what is the file extension for a typical SQL database.. ? like in access.. its .mdb..

and please don't tell me to write SQL commands like "create table and such.. " I already read about those.. I just can't imagine designing RDBMS with coding.. an IDE for SQL database would be better like access..

Re: SQL server ERROR?

Posted 09 June 2008 - 08:19 PM

I'm really sorry.. I wasn't very informative.. but heres another information..

1. I'm not connecting to any server.. (IDK i'm using my own computer as a local server ) .. in the server name I didn't typed anything.. I choosed that name.. its the only choice.. FIREPLACE\SQLEXPRESS

2. Never did change any setting.. and I'm not connecting to anything remote..

3. If I can't use SQL server and VB.net in one computer.. then that just sucks.. I don't have any server pc to test SQL ..

4. I've noticed the red icon in the SQLexpress server and its says Stopped.. so I try to Start it like any other services.. now another error pops up..

"The request failed or the server doesn't respond in a timely fashion.. check the log.. something likethat" were could I possibly find the log file.. so that I could post it here?

Re: SQL server ERROR?

Posted 10 June 2008 - 04:10 AM

Apparently you are trying to use SQL server management studio express without having SQLServer itself installed and running.
That is not going to work.
Install SQLServer (any version) and poke around in it.
And to get back to your original question: yes it does have a nice gui to build a database, create tables, and set all the details, etc.

Re: SQL server ERROR?

Posted 10 June 2008 - 05:00 AM

Quote

Apparently you are trying to use SQL server management studio express without having SQLServer itself installed and running.
That is not going to work.
Install SQLServer (any version) and poke around in it.

THANK YOU VERY MUCH FOR REPLYING.. I almost run out of hope..

well here are the things related to SQL server that were installed in my system. I'm really thankful for your time helping me out..

Re: SQL server ERROR?

In the right pane, make sure SQL Server (SQLEXPRESS) is running (see screenshot, mine is not currently running). If it isn't, then right click on it and select Properties. Select the Service tab and change the start mode to Automatic. Now switch over to the Log On tab and click the Start button. This will start the Sql Server service.

The next thing is you need to make sure that Remote Connections is allowed.

Go to Start -> Sql Server 2005 -> Configuration tools -> Sql Sever Surface Area Configuration. Select the link for the Surface Area Configuration for Services and Connections. Under the Database Engine (click the little plus sign), select Remote Connections. Make sure that Local and Remote Connections is selected and Using both TCP/IP and Named Pipes. Click OK and exit the screens.

Attached image(s)

Re: SQL server ERROR?

Now we are talking.. thanks for giving your time in trying to help me with my miseries..

I tried this one.. as you suggested..

Well I tried this.. an error again pops up..

Out of curiosity I tried click the outlined thing.. but as always .. an error pops up..

Now I've notice the configuration manager then I've tried starting it from there.. as always.. failed..

Out of all the failures so far.. I still hope that it will somewhat connect but still NOTHING.. FAILED..

I got desperate.. I tried force starting it in the services.msc .. but it also FAILED..

FAQs:

1. I'm 100% LOGGED ON as an ADMINISTRATOR..
2. I've searched and really searched the GOOGLE for possible fix.. until now.. no luck..
3. I often resolve my problems myself because I tend not to be dependent.. but this one is pretty hard..
4. If you want something.. anything.. I need to attached i'll do it immediately..
5. I tend to be informative as possible even though my post is getting pretty messy..
6. I'm a fast learner and can understand clear english instruction.. So don't hesitate.. if you want me to delete all files in my System32 folder.. if you think that would solve my problem.. I'll be happy to do it..

7. If some of the above images are not loaded. I've attached it as an
archive file .zip .. see attachments below..

THANKS A LOT FOR ALL THE EFFORTS IN HELPING ME OUT HERE.... I wish I could repay you guys with my life..

Re: SQL server ERROR?

Posted 10 June 2008 - 11:25 AM

This is first time i've used that event viewer and I'm not really sure what to do with it.. and what to look..
I've seen an export list button and exported the list of errors.. because posting them would be really messy..

Re: SQL server ERROR?

Do you have Sql Server installed in a folder that is using compression?

Instructions on enabling/disabling folder compression.

Quote

1. In My Computer or Windows Explorer, right-click the file or folder to compress or decompress.

2. Click Properties to display the Properties dialog box.

3. On the General tab, click Advanced.

4. In the Advanced Attributes dialog box, select or clear the Compress contents to save disk space check box and then click OK.

5. In the Properties dialog box, click OK.

6. If the compression state was altered for a folder, in the Confirm Attribute Changes dialog box, select whether to make the compression apply only to the selected folder or to the selected folder and all its files and subfolders. Click OK when done.

Note Windows XP Professional can compress closed paging files. However, when you restart Windows XP Professional, the paging files revert to an uncompressed state. For information about paging files, see the topics on virtual memory in Windows XP Professional Help.

Re: SQL server ERROR?

Posted 10 June 2008 - 10:11 PM

My drive C is not set to compress..

My program files is also not set to compress..

Lastly the folder where the SQL server resides..

1. I never use my DRIVE C: << were all my Dev apps reside.. as a paging file.. virtual memory..
2. And Yes I know how to setup paging file.. and I only use small part of my other partitioned drive "E" as
a paging file..

Re: SQL server ERROR?

Posted 12 June 2008 - 02:46 AM

I seriously doubt that downgrading from 3.5 to 2.0 is the solution.
I personally would try to change the order of installation: first the database, then the database tools, then the 3.5 .net framework.

Re: SQL server ERROR?

Posted 12 June 2008 - 03:23 AM

Trogdor, on 12 Jun, 2008 - 02:46 AM, said:

I seriously doubt that downgrading from 3.5 to 2.0 is the solution.
I personally would try to change the order of installation: first the database, then the database tools, then the 3.5 .net framework.

Well heres the event.. why I concluded IMO.. the framework is causing the problem..

3. I downloaded .NET FRAMEWORK 2 sp1.. and try to install it.. but an error pops up..
this version of .net is not appropriate or compatible.. blahblahblah.. with your current framework
which is 3.5 ...

4. I reinstall all .NET FRAMEWORK and reinstall, .net framework 2 << without those sp..

5. I reinstall SQL SERVER.. and it install properly.. then run properly..

Well I did say I'll probably upgraded my framework again.. Because I know its not
the main problem.. but it has something to do with it..

well I think if SQL SERVER 2005 now runs properly without any complication.. I'll probably
upgrade to .net framework 3.5 .. something to do with how chronological you do things..
microsoft's fault.. somethings need to be installed first.. it just sucks..