SQL Server 2008 connectivity problem

2012-02-15 Thread José Olavo Cerávolo
Hi Guys,   I installed a new environment for development with SQL Server 2008 R2 on Windows Server 2008 R2. I have a Windows 7 machine on the network. I can see the server on the network. I even mapped the server's S: drive on the W7 machine. I opened port 1433 on the server and on the W7, but I

Re: SQL Server 2008 connectivity problem

2012-02-15 Thread Stephen Russell
2012/2/15 José Olavo Cerávolo : > Hi Guys, > > I installed a new environment for development with SQL Server 2008 R2 on > Windows Server 2008 R2. > I have a Windows 7 machine on the network. I can see the server on the > network. > I even mapped the server's S: drive on the W7 machine. > I opened

Re: SQL Server 2008 connectivity problem

2012-02-15 Thread Alan Bourke
Did you enable named pipes and TCP inthe SQL protocols? On Wed, Feb 15, 2012, at 06:02 PM, José Olavo Cerávolo wrote: > Hi Guys, >   > I installed a new environment for development with SQL Server 2008 R2 on > Windows Server 2008 R2. > I have a Windows 7 machine on the network. I can see the serve

Re: SQL Server 2008 connectivity problem

2012-02-15 Thread Paul Hill
Also: Make sure you enabled 'Allow remote connections'. If the server is a named instance (e.g. myserver\instance) make sure the SQL Server Browser service is running (this bit me yesterday). Paul On Thu, Feb 16, 2012 at 6:12 AM, Alan Bourke wrote: > > Did you enable named pipes and TCP inthe S

RE: SQL Server 2008 connectivity problem

2012-02-16 Thread Dave Crozier
rofox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of José Olavo Cerávolo Sent: 16 February 2012 02:03 To: profoxt...@leafe.com Subject: SQL Server 2008 connectivity problem Hi Guys,   I installed a new environment for development with SQL Server 2008 R2 on Windows Server 2008 R2

RE: SQL Server 2008 connectivity problem

2012-02-16 Thread José Olavo Cerávolo
Ok, All basic configurations were taken care of. Allow remote connections, protocols, firewall. I spent a lot of time on this. I searched the internet. Tried everything I found. Now I installed Management Studio R2 and I still can't connect. When I browse on the SSMS, it finds the server, but it g

RE: SQL Server 2008 connectivity problem

2012-02-16 Thread Dave Crozier
Jose, How about Server 2008 updates Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of José Olavo Cerávolo Sent: 16 February 2012 16:49 To: profoxt...@leafe.com Subject: RE: SQL Server 2008 connectivity problem Ok, All basic

Re: SQL Server 2008 connectivity problem

2012-02-16 Thread Nicholas Geti
: Thursday, February 16, 2012 11:48 AM Subject: RE: SQL Server 2008 connectivity problem Ok, All basic configurations were taken care of. Allow remote connections, protocols, firewall. I spent a lot of time on this. I searched the internet. Tried everything I found. Now I installed Management Studio R2 a

RE: SQL Server 2008 connectivity problem

2012-02-16 Thread José Olavo Cerávolo
  Ok, don't ask me. I restarted the SQL server service and I could connect. I restarted the server 200x and I could not log in. I don't like when I don't know why something happens. Anyway, It's working!   Thanks!!! --- StripMime Report -- processed MIME parts --- multipart/alternative text/plai

Re: SQL Server 2008 connectivity problem

2012-02-16 Thread Paul Hill
Hi José , I'm sure this is the "SQL Server Browser" service problem I pointed out before... If you are connecting to a named instance this service must be running. You have it easy - my error message was in Russian! Paul On Thu, Feb 16, 2012 at 4:48 PM, José Olavo Cerávolo wrote: > Ok, All bas

Re: SQL Server 2008 connectivity problem

2012-02-16 Thread Stephen Russell
On Thu, Feb 16, 2012 at 12:10 PM, Paul Hill wrote: > Hi José , > > I'm sure this is the "SQL Server Browser" service problem I pointed > out before... > If you are connecting to a named instance this service must be running. > > You have it easy - my error message was in Russian! --- That

Re: SQL Server 2008 connectivity problem

2012-02-16 Thread Paul Hill
On Thu, Feb 16, 2012 at 6:24 PM, Stephen Russell wrote: > On Thu, Feb 16, 2012 at 12:10 PM, Paul Hill wrote: >> Hi José , >> >> I'm sure this is the "SQL Server Browser" service problem I pointed >> out before... >> If you are connecting to a named instance this service must be running. >> >> You

Re: SQL Server 2008 connectivity problem

2012-02-16 Thread Ken Dibble
> >> I'm sure this is the "SQL Server Browser" service problem I pointed > >> out before... > >> If you are connecting to a named instance this service must be running. > >> > >> You have it easy - my error message was in Russian! > > > > That my friend is a Problem! > >I think you mean comrade! >

Re: SQL Server 2008 connectivity problem

2012-02-17 Thread MB Software Solutions, LLC
On 2/16/2012 6:32 PM, Paul Hill wrote: > Olga, my contact in Moscow is very young, very blond, very hot, but > not exactly proficient in IT. NICE! Send us a picture sometime! lol ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: ht

Re: SQL Server 2008 connectivity problem

2012-02-17 Thread Stephen Russell
On Thu, Feb 16, 2012 at 5:32 PM, Paul Hill wrote: > Olga, my contact in Moscow is very young, very blond, very hot, but > not exactly proficient in IT. --- 3 out of 4 makes her a good hire. -- Stephen Russell 901.246-0159 cell ___ P

Re: RE: SQL Server 2008 connectivity problem

2012-02-16 Thread AndyD
wag - can you connect from the task pane Data Explorer in VFP9? It has some pretty obscure code in it** and I used to be able to see a lot more of a corporate network than the admins knew! ** I spent some time slogging through it one time to see if I could 'borrow' some XcodeX ideas for a gener