RE: SQL Server Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I've figured it out for myself - problem was not in the Access control as i
thought. The server has multiple IP-addresses, turns out that the SBS-did'nt
assign the servers network name to the same IP-adress as previously, so the
SQL-server is not listening on the IP-address the SBS-server has registered
in the WINS database.

Sorry for the inconveniece.

..Jesper

"Jesper Hauge" wrote:

> Hello all
>
> I've recently switched from a P2P workgroup to a SBS2003 Domain. Basically
> I've installed a new server runnning SBS, and then used
> sbsserver/connectcomputer to add my existing workstations and Windows 2003
> server to the domain.
>
> My problem is that I am no longer able to connect to the SQL server running
> on the other Win2003 server via Enteprise manager on my workstation. Heres
> what I have already tried:
>
> - I've checked that the SQL server is communication via TCP/IP on port 1433,
> I can connect via telnet to port 1433 on the server.
>
> - I've added the "domain\Power Users" group of which my windows account is a
> member to the "security/logins" section of the enterprise manager on the
> server and checked the "System administrators" role for this group.
>
> - I've tried using the "sa" account for remote access via Enterprise Manager
> and Query Analyzer, but I recieve the same error message as when I am using
> my windows account.
>
> What am I missing? Help and comments very much appreciated.
>
> Regards
> Jesper Hauge
.

Relevant Pages

  • RE: Some technical errors
    ... If the SMTP server is not running on port 25 TCP it is not a public ... Manager - Computer Assurance Services BDO Chartered Accountants & ...
    (Security-Basics)
  • Re: SRV RRs support in Internet Explorer?
    ... The port number could be implicit (i.e. ... At any point in time, a server could fail ... can't effectively LB or backup because NSs cache the records for the TTL ... I still don't see how SRV records would help backup or LB. ...
    (microsoft.public.win2000.dns)
  • Re: Still cant connect to RWW or OWA remotely
    ... I get 'cannot find server or dns error' on both ... TCP [port number]> to open the ports. ... As for error messages when I fail to access RWW with the laptop, ... network, no connection seems possible. ...
    (microsoft.public.windows.server.sbs)
  • Re: cannot send mail from Windows mail
    ... When a username/password combination doesn't work in Windows Mail, ... I mean I dont use it but as outgoing address for my ISP account. ... youir username and password are correct for your mail server". ... Ask your home ISP if they support SMTP on a port other than 25. ...
    (microsoft.public.windows.vista.mail)
  • Re: How to trigger server to reattempt printer connection
    ... The spooler does not log any SNMP data. ... Best practices and known issues when you install Windows Server 2003 Service ... Before restarting the spooler next time, create a new port name to the ... This does not happen often, but when it does, it seems to stay offline ...
    (microsoft.public.windows.server.general)