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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 NEW TO SQL SERVER - ANY HELP ?

Author  Topic 

mendezjosem
Starting Member

4 Posts

Posted - 2008-07-12 : 01:27:15
Hi my name is Jose,

I had been working on a VB 6.0 Application wich uses Access Database. After runing the application on networks, it is very slow. Doing some reaserch I read that MS SQL Server is 10 times more faster. I have MS SQL SERVER 2005 on Vista Premium.

I installed and Im VERY LOST HERE!.

I tried tutorials but I cannt get started since, on the Sfirst dialog that appears is a "Connect To Server", I cannt select the server since is blank. I click Browse and doesnt appear any server.

(By the way when I install it it tells me ISS wasnt there, I isntall ISS and then run MS SQL installation and keeps tellingme that. I even run "localhost' (something like that) and shows that is installed. My question is :

DO I need ISS ?
How can I connect to a server, or create a simple connection. What I want to do is connect my access database or make my database to work. I know I need to convert it but how since I cannt even log)

Any help ?
Thanks a lot

mendezjosem
Starting Member

4 Posts

Posted - 2008-07-12 : 01:28:25
I have "logmein", I can even pay for someone by paypal if helps me to setup this.

Thanks,
Jose
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-12 : 02:05:16
are you trying to connect access db from sql server?
Go to Top of Page

mendezjosem
Starting Member

4 Posts

Posted - 2008-07-12 : 02:10:18
No. I have access databae but I will want to convert that database to ms sql server database.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-12 : 02:18:25
see http://www.microsoft.com/sql/solutions/migration/default.mspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-12 : 02:21:21
quote:
Originally posted by mendezjosem


I tried tutorials but I cannt get started since, on the Sfirst dialog that appears is a "Connect To Server", I cannt select the server since is blank. I click Browse and doesnt appear any server.



Use hostname if you installed the default instance, otherwise use hostname\instancename for a named instance. To get the value of hostname, type in hostname in a cmd window (Start..Run..cmd). To get the instance name, check SQL Server Configuration Manager.

And by ISS, do you mean IIS? If so, IIS is not required to use SQL Server. In fact, it is not recommended to have IIS and the SQL Server engine on the same machine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

mendezjosem
Starting Member

4 Posts

Posted - 2008-07-12 : 16:23:49
how much can you charge me to configure my sql ?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-12 : 16:50:49
I'll send you a PM with what I'd charge, but be warned it's not cheap to hire a consultant. You can get free help here which is what I would recommend.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -