Cannot find mdf files: text

Showing posts with label text. Show all posts

Tuesday, March 27, 2012

Cannot Register Remote Server

This is a multi-part message in MIME format.
--=_NextPart_000_0038_01C6ACCB.8D05BD60
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Dear all,
I've installed SQL2005 on my local machine. And there is another SERVER = which has install both SQL2000 and SQL2005. I can use my local = Management Studio to register the SERVER\SQL2000 instance but I cannot = register SERVER\SQL2005 instance.
How can I register and connect to the SERVER\SQL2005 server?
The SERVER\SQL2005 has been configured to enable the protocols of shared = memory, namepipe and tcpip already.
The SERVER has installed SQL2000 first and then install SQL2005 server.
Thanks a lot.
Regards,
Alex AU
--=_NextPart_000_0038_01C6ACCB.8D05BD60
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Dear all,

I've installed SQL2005 on my local = machine. And there is another SERVER which has install both SQL2000 and SQL2005. = I can use my local Management Studio to register the SERVER\SQL2000 instance = but I cannot register SERVER\SQL2005 instance.

How can I register and connect = to the SERVER\SQL2005 server?

The SERVER\SQL2005 has been = configured to enable the protocols of shared memory, namepipe and = tcpip already.

The SERVER has installed SQL2000 = first and then install SQL2005 server.

Thanks a lot.

Regards,

Alex AU
--=_NextPart_000_0038_01C6ACCB.8D05BD60--Hi Alex
Can you conncet to this server using SQLCMD? If not check that Remote
Connections have been set in the surface area configuration tool.
John
"Alex AU" wrote:
> Dear all,
> I've installed SQL2005 on my local machine. And there is another SERVER which has install both SQL2000 and SQL2005. I can use my local Management Studio to register the SERVER\SQL2000 instance but I cannot register SERVER\SQL2005 instance.
> How can I register and connect to the SERVER\SQL2005 server?
> The SERVER\SQL2005 has been configured to enable the protocols of shared memory, namepipe and tcpip already.
> The SERVER has installed SQL2000 first and then install SQL2005 server.
> Thanks a lot.
>
> Regards,
> Alex AU|||This is a multi-part message in MIME format.
--000100040600010001030705
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Alex AU wrote:
> Dear all,
> I've installed SQL2005 on my local machine. And there is another
> SERVER which has install both SQL2000 and SQL2005. I can use my local
> Management Studio to register the SERVER\SQL2000 instance but I cannot
> register SERVER\SQL2005 instance.
> How can I register and connect to the SERVER\SQL2005 server?
> The SERVER\SQL2005 has been configured to enable the protocols
> of shared memory, namepipe and tcpip already.
> The SERVER has installed SQL2000 first and then install SQL2005 server.
> Thanks a lot.
>
> Regards,
> Alex AU
Are both SQL2000 and SQL2005 installed as named instances on the server?
It could be that SQL2000 is installed as a default instance (hence you
can connect to it just with the servername) and SQL2005 is installed as
a named instance so you need to use that instance name to connect.
Regards
Steen SchlÃ¼ter Persson
Databaseadministrator / Systemadministrator
--000100040600010001030705
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Alex AU wrote:
<blockquote cite="mid%234kVSiIrGHA.3680@.TK2MSFTNGP02.phx.gbl"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<style></style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<div><font face="Times New Roman">Dear all,</font></div>
<div>Â </div>
<div><font face="Times New Roman">I've installed SQL2005 on my local
machine. And there is another SERVER which has install both SQL2000 and
SQL2005. I can use my local Management Studio to register the
SERVER\SQL2000 instance but I cannot register SERVER\SQL2005 instance.</font></div>
<div>Â </div>
<div><font face="Times New Roman">How can IÂ register and connect to
the SERVER\SQL2005 server? </font></div>
<div>Â </div>
<div><font face="Times New Roman">The SERVER\SQL2005 has been
configured toÂ enable the protocols ofÂ shared memory, namepipeÂ and tcpip
already.</font></div>
<div>Â </div>
<div><font face="Times New Roman">The SERVER has installed SQL2000
first and then install SQL2005 server.</font></div>
<div>Â </div>
<div><font face="Times New Roman">Thanks a lot.</font></div>
<div>Â </div>
<div>
<div>
<div>
<div>Â </div>
<div>Â </div>
<div><font face="Times New Roman">Regards,</font></div>
<div>Â </div>
<div><font face="Times New Roman">Alex AU</font></div>
</div>
</div>
</div>
</blockquote>
<font size="-1"><font face="Arial">Are both SQL2000 and SQL2005
installed as named instances on the server? It could be that SQL2000 is
installed as a default instance (hence you can connect to it just with
the servername) and SQL2005 is installed as a named instance so you
need to use that instance name to connect.</font></font><br>
<br>
<br>
-- <br>
Regards<br>
Steen SchlÃ¼ter Persson<br>
Databaseadministrator / Systemadministrator<br>
</body>
</html>
--000100040600010001030705--|||This is a multi-part message in MIME format.
--=_NextPart_000_002F_01C6ADE7.6B1D97F0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Dear John,
I've already setup the remote connections to accept namepine and tcpip =connection in the surface area configuration tool.
I can use ODBC to establish connection from my workstation to the =SERVER\SQL2005 but just cannot register the server in the Management =Studio on my workstation.
Thanks.
Regards,
Alex AU
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:3238D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...
Hi Alex
Can you conncet to this server using SQLCMD? If not check that Remote Connections have been set in the surface area configuration tool.
John
"Alex AU" wrote:
> Dear all,
> > I've installed SQL2005 on my local machine. And there is another =SERVER which has install both SQL2000 and SQL2005. I can use my local =Management Studio to register the SERVER\SQL2000 instance but I cannot =register SERVER\SQL2005 instance.
> > How can I register and connect to the SERVER\SQL2005 server? > > The SERVER\SQL2005 has been configured to enable the protocols of =shared memory, namepipe and tcpip already.
> > The SERVER has installed SQL2000 first and then install SQL2005 =server.
> > Thanks a lot.
> > > > Regards,
> > Alex AU
--=_NextPart_000_002F_01C6ADE7.6B1D97F0
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Dear John,
I've already setup the remote =connections to accept namepine and tcpip connection in the surface area configuration tool.
I can use ODBC to establish =connection from my workstation to the SERVER\SQL2005 but just cannot register the server in =the Management Studio on my workstation.
Thanks.
Regards,
Alex AU
"John Bell" wrote in message news:323=8D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...Hi AlexCan you conncet to this server using SQLCMD? If not check =that Remote Connections have been set in the surface area configuration = tool.John"Alex AU" wrote:> Dear =all,> > I've installed SQL2005 on my local machine. And there is =another SERVER which has install both SQL2000 and SQL2005. I can use my local Management Studio to register the SERVER\SQL2000 instance but I cannot = register SERVER\SQL2005 instance.> > How can I register =and connect to the SERVER\SQL2005 server? > > The =SERVER\SQL2005 has been configured to enable the protocols of shared memory, namepipe and =tcpip already.> > The SERVER has installed SQL2000 first and =then install SQL2005 server.> > Thanks a lot.> => > > Regards,> > Alex =AU

--=_NextPart_000_002F_01C6ADE7.6B1D97F0--|||This is a multi-part message in MIME format.
--=_NextPart_000_0041_01C6ADE7.D964CB70
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Dear Steen,
The SQL2000 is the default instance and SQL2005 is a named instance. =When I register the SQL2005 on my workstation's Management Studio, I've =already used the name instance to try connect but it failed.
I've already set the remote connection with namepipe and tcpip in the =service area configuration on the server. When I try to use ODBC on my =workstation to connect to the SERVER\SQL2005, I can successfully =establish the connection. I just cannot register the SERVER\SQL2005 on =my workstation's management studio.
Thanks
Regards,
Alex AU
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message =news:u0NxbpJrGHA.2256@.TK2MSFTNGP03.phx.gbl...
Alex AU wrote: Dear all,
I've installed SQL2005 on my local machine. And there is another =SERVER which has install both SQL2000 and SQL2005. I can use my local =Management Studio to register the SERVER\SQL2000 instance but I cannot =register SERVER\SQL2005 instance.
How can I register and connect to the SERVER\SQL2005 server?
The SERVER\SQL2005 has been configured to enable the protocols of =shared memory, namepipe and tcpip already.
The SERVER has installed SQL2000 first and then install SQL2005 =server.
Thanks a lot.
Regards,
Alex AU
Are both SQL2000 and SQL2005 installed as named instances on the =server? It could be that SQL2000 is installed as a default instance =(hence you can connect to it just with the servername) and SQL2005 is =installed as a named instance so you need to use that instance name to =connect.
-- Regards
Steen Schl=C3=BCter Persson
Databaseadministrator / Systemadministrator
--=_NextPart_000_0041_01C6ADE7.D964CB70
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Dear Steen,
The SQL2000 is the default instance =and SQL2005 is a named instance. When I register the SQL2005 on my =workstation's Management Studio, I've already used the name instance to try connect =but it failed.
I've already set the remote =connection with namepipe and tcpip in the service area configuration on the server. =When I try to use ODBC on my workstation to connect to the SERVER\SQL2005, I =can successfully establish the connection. I just cannot register the =SERVER\SQL2005 on my workstation's management studio.
Thanks
Regards,
Alex AU
"Steen Persson (DK)" wrote in =message news:u0NxbpJrGHA.2256=@.TK2MSFTNGP03.phx.gbl...Alex AU wrote:
Dear all,

I've installed SQL2005 on my =local machine. And there is another SERVER which has install both SQL2000 =and SQL2005. I can use my local Management Studio to register the =SERVER\SQL2000 instance but I cannot register SERVER\SQL2005 instance.

How can I register and =connect to the SERVER\SQL2005 server?

The SERVER\SQL2005 has been =configured to enable the protocols of shared memory, =namepipe and tcpip already.

The SERVER has installed SQL2000 =first and then install SQL2005 server.

Thanks a lot.

Regards,

Alex AUAre both SQL2000 and SQL2005 installed as named instances =on the server? It could be that SQL2000 is installed as a default instance =(hence you can connect to it just with the servername) and SQL2005 is installed =as a named instance so you need to use that instance name to connect.-- RegardsSteen =Schl=C3=BCter PerssonDatabaseadministrator / Systemadministrator

--=_NextPart_000_0041_01C6ADE7.D964CB70--|||Hi Alex
And SQLCMD allows you to connect?
John
"Alex AU" wrote:
> Dear John,
> I've already setup the remote connections to accept namepine and tcpip
> connection in the surface area configuration tool.
> I can use ODBC to establish connection from my workstation to the
> SERVER\SQL2005 but just cannot register the server in the Management
> Studio on my workstation.
> Thanks.
>
> Regards,
> Alex AU
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3238D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...
> Hi Alex
> Can you conncet to this server using SQLCMD? If not check that Remote
> Connections have been set in the surface area configuration tool.
> John
> "Alex AU" wrote:
> > Dear all,
> >
> > I've installed SQL2005 on my local machine. And there is another
> SERVER which has install both SQL2000 and SQL2005. I can use my local
> Management Studio to register the SERVER\SQL2000 instance but I cannot
> register SERVER\SQL2005 instance.
> >
> > How can I register and connect to the SERVER\SQL2005 server?
> >
> > The SERVER\SQL2005 has been configured to enable the protocols of
> shared memory, namepipe and tcpip already.
> >
> > The SERVER has installed SQL2000 first and then install SQL2005
> server.
> >
> > Thanks a lot.
> >
> >
> >
> > Regards,
> >
> > Alex AU
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0103_01C6AF00.EB2418B0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Dear John,
I've tried sqlcmd, it also failed. The command I used and error as =follow:
sqlcmd -S SERVER\SQL2005
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified =[xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while =establi
shing a connection to the server. When connecting to SQL Server 2005, =this failu
re may be caused by the fact that under the default settings SQL Server =does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
Thanks a lot.
Regards,
Alex AU
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:342A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...
Hi Alex
And SQLCMD allows you to connect?
John
"Alex AU" wrote:
> Dear John,
> > I've already setup the remote connections to accept namepine and =tcpip
> connection in the surface area configuration tool.
> > I can use ODBC to establish connection from my workstation to the
> SERVER\SQL2005 but just cannot register the server in the Management
> Studio on my workstation.
> > Thanks.
> > > > Regards,
> > Alex AU
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3238D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...
> Hi Alex
> > Can you conncet to this server using SQLCMD? If not check that =Remote
> Connections have been set in the surface area configuration tool.
> > John
> > "Alex AU" wrote:
> > > Dear all,
> >
> > I've installed SQL2005 on my local machine. And there is another
> SERVER which has install both SQL2000 and SQL2005. I can use my =local
> Management Studio to register the SERVER\SQL2000 instance but I =cannot
> register SERVER\SQL2005 instance.
> >
> > How can I register and connect to the SERVER\SQL2005 server?
> >
> > The SERVER\SQL2005 has been configured to enable the protocols =of
> shared memory, namepipe and tcpip already.
> >
> > The SERVER has installed SQL2000 first and then install SQL2005
> server.
> >
> > Thanks a lot.
> >
> >
> >
> > Regards,
> >
> > Alex AU
>
--=_NextPart_000_0103_01C6AF00.EB2418B0
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Dear John,
I've tried sqlcmd, it also failed. =The command I used and error as follow:
sqlcmd -S =SERVER\SQL2005
HResult 0xFFFFFFFF, Level 16, State =1SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].Sqlcmd: Error: Microsoft SQL Native Client : An error =has occurred while establishing a connection to the server. When =connecting to SQL Server 2005, this failure may be caused by the fact that under =the default settings SQL Server does not allow remote connections..Sqlcmd: Error: Microsoft SQL Native Client : Login =timeout expired.
Thanks a lot.
Regards,
Alex AU
"John Bell" wrote in message news:342=A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...Hi AlexAnd SQLCMD allows you to connect?John"Alex =AU" wrote:> Dear John,> > I've already setup the =remote connections to accept namepine and tcpip> connection in the =surface area configuration tool.> > I can use ODBC to establish connection from my workstation to the> SERVER\SQL2005 but just =cannot register the server in the Management> Studio on my workstation.> > Thanks.> > > => Regards,> > Alex AU> "John Bell" = wrote in message> news:323=8D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...> =; Hi Alex> > Can you conncet to this server =using SQLCMD? If not check that Remote> Connections have =been set in the surface area configuration tool.> > John> > "Alex AU" wrote:> > > Dear all,> >> > I've installed SQL2005 on my local =machine. And there is another> SERVER which has install both SQL2000 and =SQL2005. I can use my local> Management Studio to register the =SERVER\SQL2000 instance but I cannot> register SERVER\SQL2005 instance.> >> > How can I =register and connect to the SERVER\SQL2005 server?> >> > The SERVER\SQL2005 has been configured =to enable the protocols of> shared memory, namepipe and tcpip already.> >> > The SERVER =has installed SQL2000 first and then install SQL2005> server.> >> > Thanks a lot.> >> =>> >> > Regards,> >> > Alex =AU>

--=_NextPart_000_0103_01C6AF00.EB2418B0--|||Hi Alex
This is indicating that the remote connections setting are not set on the
protocols. What does the SQLServer 2005 Configuration Manager tool say (i.e.
not SAC!). Also make sure that you can resolve the server name correctly.
You may also want to look at SQLPing to to see to search for servers
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
John
"Alex AU" wrote:
> Dear John,
> I've tried sqlcmd, it also failed. The command I used and error as follow:
> sqlcmd -S SERVER\SQL2005
> HResult 0xFFFFFFFF, Level 16, State 1
> SQL Network Interfaces: Error Locating Server/Instance Specified
> [xFFFFFFFF].
> Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
> establi
> shing a connection to the server. When connecting to SQL Server 2005, this
> failu
> re may be caused by the fact that under the default settings SQL Server
> does not
> allow remote connections..
> Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
> Thanks a lot.
>
> Regards,
> Alex AU
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:342A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...
> Hi Alex
> And SQLCMD allows you to connect?
> John
> "Alex AU" wrote:
> > Dear John,
> >
> > I've already setup the remote connections to accept namepine and tcpip
> > connection in the surface area configuration tool.
> >
> > I can use ODBC to establish connection from my workstation to the
> > SERVER\SQL2005 but just cannot register the server in the Management
> > Studio on my workstation.
> >
> > Thanks.
> >
> >
> >
> > Regards,
> >
> > Alex AU
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:3238D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...
> > Hi Alex
> >
> > Can you conncet to this server using SQLCMD? If not check that
> Remote
> > Connections have been set in the surface area configuration tool.
> >
> > John
> >
> > "Alex AU" wrote:
> >
> > > Dear all,
> > >
> > > I've installed SQL2005 on my local machine. And there is another
> > SERVER which has install both SQL2000 and SQL2005. I can use my local
> > Management Studio to register the SERVER\SQL2000 instance but I cannot
> > register SERVER\SQL2005 instance.
> > >
> > > How can I register and connect to the SERVER\SQL2005 server?
> > >
> > > The SERVER\SQL2005 has been configured to enable the protocols of
> > shared memory, namepipe and tcpip already.
> > >
> > > The SERVER has installed SQL2000 first and then install SQL2005
> > server.
> > >
> > > Thanks a lot.
> > >
> > >
> > >
> > > Regards,
> > >
> > > Alex AU
> >
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0017_01C6AF40.AEAD7990
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Thanks John,
I've used the tools on that SERVER and I've found that the port number =for SQL2005 using is 1025. (SQL2000 use 1433).
I finally figure out what causing the connection issue, it's the =firewall settings. I use a Windows XP with SP2 as a server and the =firewall has turned on. It only allow SQL connection from port 1433 and =that's the reason why I cannot connect with SQL Management Studio with =port 1025 (SQL2005). When I shut down the firewall, it works.
Sorry for the chaos that I've made. But I really appreciate for your =kindly help.
I've got one more question related to this. I've tried to add exception =rule in the XP firewall settings for port 1025, but I still cannot =connect. I can only connect when the firewall is off. Can anyone help =with this? (or should I post in other newsgroup for this issue?)
Thanks.
Regards,
Alex AU
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:E4A5B93E-6A03-4406-87B6-399E4A150D02@.microsoft.com...
Hi Alex
This is indicating that the remote connections setting are not set on =the protocols. What does the SQLServer 2005 Configuration Manager tool say =(i.e. not SAC!). Also make sure that you can resolve the server name =correctly.
You may also want to look at SQLPing to to see to search for servers http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
John
"Alex AU" wrote:
> Dear John,
> > I've tried sqlcmd, it also failed. The command I used and error as =follow:
> > sqlcmd -S SERVER\SQL2005
> > HResult 0xFFFFFFFF, Level 16, State 1
> SQL Network Interfaces: Error Locating Server/Instance Specified
> [xFFFFFFFF].
> Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred =while
> establi
> shing a connection to the server. When connecting to SQL Server =2005, this
> failu
> re may be caused by the fact that under the default settings SQL =Server
> does not
> allow remote connections..
> Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
> > Thanks a lot.
> > > > Regards,
> > Alex AU
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:342A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...
> Hi Alex
> > And SQLCMD allows you to connect?
> > John
> > "Alex AU" wrote:
> > > Dear John,
> >
> > I've already setup the remote connections to accept namepine and =tcpip
> > connection in the surface area configuration tool.
> >
> > I can use ODBC to establish connection from my workstation to =the
> > SERVER\SQL2005 but just cannot register the server in the =Management
> > Studio on my workstation.
> >
> > Thanks.
> >
> >
> >
> > Regards,
> >
> > Alex AU
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:3238D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...
> > Hi Alex
> >
> > Can you conncet to this server using SQLCMD? If not check that
> Remote
> > Connections have been set in the surface area configuration =tool.
> >
> > John
> >
> > "Alex AU" wrote:
> >
> > > Dear all,
> > >
> > > I've installed SQL2005 on my local machine. And there is =another
> > SERVER which has install both SQL2000 and SQL2005. I can use my =local
> > Management Studio to register the SERVER\SQL2000 instance but I =cannot
> > register SERVER\SQL2005 instance.
> > >
> > > How can I register and connect to the SERVER\SQL2005 server?
> > >
> > > The SERVER\SQL2005 has been configured to enable the =protocols of
> > shared memory, namepipe and tcpip already.
> > >
> > > The SERVER has installed SQL2000 first and then install =SQL2005
> > server.
> > >
> > > Thanks a lot.
> > >
> > >
> > >
> > > Regards,
> > >
> > > Alex AU
> >
>
--=_NextPart_000_0017_01C6AF40.AEAD7990
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Thanks John,
I've used the tools on that SERVER =and I've found that the port number for SQL2005 using is 1025. (SQL2000 use 1433).
I finally figure out what causing =the connection issue, it's the firewall settings. I use a Windows XP with =SP2 as a server and the firewall has turned on. It only allow SQL connection from =port 1433 and that's the reason why I cannot connect with SQL Management =Studio with port 1025 (SQL2005). When I shut down the firewall, it =works.
Sorry for the chaos that I've made. =But I really appreciate for your kindly help.
I've got one more question related to this. I've tried to add exception rule in the XP firewall =settings for port 1025, but I still cannot connect. I can only connect when the =firewall is off. Can anyone help with this? (or should I post in other newsgroup for this issue?)
Thanks.
Regards,
Alex AU
"John Bell" wrote in message news:E4A=5B93E-6A03-4406-87B6-399E4A150D02@.microsoft.com...Hi AlexThis is indicating that the remote connections setting are =not set on the protocols. What does the SQLServer 2005 Configuration =Manager tool say (i.e. not SAC!). Also make sure that you can resolve the =server name correctly.You may also want to look at SQLPing to to see to =search for servers http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx=John"Alex AU" wrote:> Dear John,> > I've tried sqlcmd, =it also failed. The command I used and error as follow:> > =sqlcmd -S SERVER\SQL2005> > HResult 0xFFFFFFFF, Level 16, State =1> SQL Network Interfaces: Error Locating Server/Instance =Specified> [xFFFFFFFF].> Sqlcmd: Error: Microsoft SQL Native Client : An =error has occurred while> establi> shing a connection to the =server. When connecting to SQL Server 2005, this> failu> re may be =caused by the fact that under the default settings SQL Server> does not> allow remote connections..> Sqlcmd: Error: =Microsoft SQL Native Client : Login timeout expired.> > Thanks a lot.> > > > Regards,> > Alex = AU> > "John Bell" wrote in message> news:342=A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...> =; Hi Alex> > And SQLCMD allows you to =connect?> > John> > "Alex AU" wrote:> > > Dear =John,> >> > I've already setup the remote =connections to accept namepine and tcpip> > connection in the =surface area configuration tool.> >> => I can use ODBC to establish connection from my workstation to the> > SERVER\SQL2005 but just cannot register =the server in the Management> > Studio on my workstation.> >> > Thanks.> >> =>> >> > Regards,> >> > Alex AU> => "John Bell" wrote in message> > news:323=8D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...> =; > Hi Alex> >> > Can you conncet to this server using SQLCMD? If not =check that> Remote> > Connections =have been set in the surface area configuration tool.> >> > John> >> > "Alex AU" =wrote:> >> > > Dear =all,> > >> > > I've =installed SQL2005 on my local machine. And there is another> => SERVER which has install both SQL2000 and SQL2005. I can use my local> > Management Studio to register the SERVER\SQL2000 instance but I cannot> > register = SERVER\SQL2005 instance.> > >> > > How can I register and =connect to the SERVER\SQL2005 server?> > >> > > The SERVER\SQL2005 has =been configured to enable the protocols of> > shared =memory, namepipe and tcpip already.> > >> > > The SERVER has =installed SQL2000 first and then install SQL2005> > server.> > >> > > Thanks a lot.> => >> > >> > >> > > Regards,> > >> = > > Alex AU> >>

--=_NextPart_000_0017_01C6AF40.AEAD7990--|||Hi
I don't know the intricacies of the XP firewall as I have always used a
third party one. The following describes what you should need to set up in
terms of rules, change this for the port you are using and it should be ok.
http://support.microsoft.com/kb/287932
John
"Alex AU" wrote:
> Thanks John,
> I've used the tools on that SERVER and I've found that the port number for
> SQL2005 using is 1025. (SQL2000 use 1433).
> I finally figure out what causing the connection issue, it's the firewall
> settings. I use a Windows XP with SP2 as a server and the firewall has
> turned on. It only allow SQL connection from port 1433 and that's the
> reason why I cannot connect with SQL Management Studio with port 1025
> (SQL2005). When I shut down the firewall, it works.
> Sorry for the chaos that I've made. But I really appreciate for your
> kindly help.
> I've got one more question related to this. I've tried to add exception
> rule in the XP firewall settings for port 1025, but I still cannot
> connect. I can only connect when the firewall is off. Can anyone help with
> this? (or should I post in other newsgroup for this issue?)
> Thanks.
>
> Regards,
> Alex AU
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E4A5B93E-6A03-4406-87B6-399E4A150D02@.microsoft.com...
> Hi Alex
> This is indicating that the remote connections setting are not set on
> the
> protocols. What does the SQLServer 2005 Configuration Manager tool say
> (i.e.
> not SAC!). Also make sure that you can resolve the server name
> correctly.
> You may also want to look at SQLPing to to see to search for servers
> http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
> John
> "Alex AU" wrote:
> > Dear John,
> >
> > I've tried sqlcmd, it also failed. The command I used and error as
> follow:
> >
> > sqlcmd -S SERVER\SQL2005
> >
> > HResult 0xFFFFFFFF, Level 16, State 1
> > SQL Network Interfaces: Error Locating Server/Instance Specified
> > [xFFFFFFFF].
> > Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred
> while
> > establi
> > shing a connection to the server. When connecting to SQL Server 2005,
> this
> > failu
> > re may be caused by the fact that under the default settings SQL
> Server
> > does not
> > allow remote connections..
> > Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
> >
> > Thanks a lot.
> >
> >
> >
> > Regards,
> >
> > Alex AU
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:342A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...
> > Hi Alex
> >
> > And SQLCMD allows you to connect?
> >
> > John
> >
> > "Alex AU" wrote:
> >
> > > Dear John,
> > >
> > > I've already setup the remote connections to accept namepine and
> tcpip
> > > connection in the surface area configuration tool.
> > >
> > > I can use ODBC to establish connection from my workstation to the
> > > SERVER\SQL2005 but just cannot register the server in the
> Management
> > > Studio on my workstation.
> > >
> > > Thanks.
> > >
> > >
> > >
> > > Regards,
> > >
> > > Alex AU
> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > news:3238D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...
> > > Hi Alex
> > >
> > > Can you conncet to this server using SQLCMD? If not check that
> > Remote
> > > Connections have been set in the surface area configuration
> tool.
> > >
> > > John
> > >
> > > "Alex AU" wrote:
> > >
> > > > Dear all,
> > > >
> > > > I've installed SQL2005 on my local machine. And there is
> another
> > > SERVER which has install both SQL2000 and SQL2005. I can use my
> local
> > > Management Studio to register the SERVER\SQL2000 instance but I
> cannot
> > > register SERVER\SQL2005 instance.
> > > >
> > > > How can I register and connect to the SERVER\SQL2005 server?
> > > >
> > > > The SERVER\SQL2005 has been configured to enable the protocols
> of
> > > shared memory, namepipe and tcpip already.
> > > >
> > > > The SERVER has installed SQL2000 first and then install
> SQL2005
> > > server.
> > > >
> > > > Thanks a lot.
> > > >
> > > >
> > > >
> > > > Regards,
> > > >
> > > > Alex AU
> > >
> >
>|||This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C6AF97.8BFAF4C0
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Dear John,
Thanks for your great help. With your information, I found another =article that detailed the settings needed for XP firewall settings for =SQL2005 and would like to share here.
http://support.microsoft.com/kb/914277/en-us
Now I can connect to the SQL2005 instance on the XP workstation.
Thanks again.
Regards,
Alex AU
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message =news:844977CE-C5D2-4A3A-A29D-5DA1613C476C@.microsoft.com...
Hi
I don't know the intricacies of the XP firewall as I have always used =a third party one. The following describes what you should need to set =up in terms of rules, change this for the port you are using and it should =be ok. http://support.microsoft.com/kb/287932
John
"Alex AU" wrote:
> Thanks John,
> > I've used the tools on that SERVER and I've found that the port =number for
> SQL2005 using is 1025. (SQL2000 use 1433).
> > I finally figure out what causing the connection issue, it's the =firewall
> settings. I use a Windows XP with SP2 as a server and the firewall =has
> turned on. It only allow SQL connection from port 1433 and that's =the
> reason why I cannot connect with SQL Management Studio with port =1025
> (SQL2005). When I shut down the firewall, it works.
> > Sorry for the chaos that I've made. But I really appreciate for your
> kindly help.
> > I've got one more question related to this. I've tried to add =exception
> rule in the XP firewall settings for port 1025, but I still cannot
> connect. I can only connect when the firewall is off. Can anyone =help with
> this? (or should I post in other newsgroup for this issue?)
> > Thanks.
> > > > Regards,
> > Alex AU
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E4A5B93E-6A03-4406-87B6-399E4A150D02@.microsoft.com...
> Hi Alex
> > This is indicating that the remote connections setting are not set =on
> the
> protocols. What does the SQLServer 2005 Configuration Manager tool =say
> (i.e.
> not SAC!). Also make sure that you can resolve the server name
> correctly.
> > You may also want to look at SQLPing to to see to search for =servers
> http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
> > John
> > "Alex AU" wrote:
> > > Dear John,
> >
> > I've tried sqlcmd, it also failed. The command I used and error =as
> follow:
> >
> > sqlcmd -S SERVER\SQL2005
> >
> > HResult 0xFFFFFFFF, Level 16, State 1
> > SQL Network Interfaces: Error Locating Server/Instance Specified
> > [xFFFFFFFF].
> > Sqlcmd: Error: Microsoft SQL Native Client : An error has =occurred
> while
> > establi
> > shing a connection to the server. When connecting to SQL Server =2005,
> this
> > failu
> > re may be caused by the fact that under the default settings SQL
> Server
> > does not
> > allow remote connections..
> > Sqlcmd: Error: Microsoft SQL Native Client : Login timeout =expired.
> >
> > Thanks a lot.
> >
> >
> >
> > Regards,
> >
> > Alex AU
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:342A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...
> > Hi Alex
> >
> > And SQLCMD allows you to connect?
> >
> > John
> >
> > "Alex AU" wrote:
> >
> > > Dear John,
> > >
> > > I've already setup the remote connections to accept namepine =and
> tcpip
> > > connection in the surface area configuration tool.
> > >
> > > I can use ODBC to establish connection from my workstation =to the
> > > SERVER\SQL2005 but just cannot register the server in the
> Management
> > > Studio on my workstation.
> > >
> > > Thanks.
> > >
> > >
> > >
> > > Regards,
> > >
> > > Alex AU
> > > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > > news:3238D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...
> > > Hi Alex
> > >
> > > Can you conncet to this server using SQLCMD? If not check =that
> > Remote
> > > Connections have been set in the surface area =configuration
> tool.
> > >
> > > John
> > >
> > > "Alex AU" wrote:
> > >
> > > > Dear all,
> > > >
> > > > I've installed SQL2005 on my local machine. And there is
> another
> > > SERVER which has install both SQL2000 and SQL2005. I can use =my
> local
> > > Management Studio to register the SERVER\SQL2000 instance =but I
> cannot
> > > register SERVER\SQL2005 instance.
> > > >
> > > > How can I register and connect to the SERVER\SQL2005 =server?
> > > >
> > > > The SERVER\SQL2005 has been configured to enable the =protocols
> of
> > > shared memory, namepipe and tcpip already.
> > > >
> > > > The SERVER has installed SQL2000 first and then install
> SQL2005
> > > server.
> > > >
> > > > Thanks a lot.
> > > >
> > > >
> > > >
> > > > Regards,
> > > >
> > > > Alex AU
> > >
> >
>
--=_NextPart_000_000F_01C6AF97.8BFAF4C0
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Dear John,
Thanks for your great help. With =your information, I found another article that =detailed the settings needed for XP firewall settings for SQL2005 and would like =to share here.
http://support.microsoft.com/kb/914277/en-us">http://support.micr=osoft.com/kb/914277/en-us
Now I can connect to the SQL2005 =instance on the XP workstation.
Thanks again.
Regards,
Alex AU
"John Bell" wrote in message news:844=977CE-C5D2-4A3A-A29D-5DA1613C476C@.microsoft.com...HiI don't know the intricacies of the XP firewall as I have always used a third party one. The following describes what you should need to =set up in terms of rules, change this for the port you are using and it =should be ok. http://support.microsoft.com/kb/287932">http://support.microsoft.=com/kb/287932John"Alex AU" wrote:> Thanks John,> > I've used the =tools on that SERVER and I've found that the port number for> SQL2005 =using is 1025. (SQL2000 use 1433).> > I finally figure out what =causing the connection issue, it's the firewall> settings. I use a =Windows XP with SP2 as a server and the firewall has> turned on. It only =allow SQL connection from port 1433 and that's the> reason why I cannot =connect with SQL Management Studio with port 1025> (SQL2005). When I =shut down the firewall, it works.> > Sorry for the chaos that I've =made. But I really appreciate for your> kindly help.> > =I've got one more question related to this. I've tried to add =exception> rule in the XP firewall settings for port 1025, but I still =cannot> connect. I can only connect when the firewall is off. Can anyone help with> this? (or should I post in other newsgroup for this issue?)> > Thanks.> > > > Regards,> > Alex AU> > "John =Bell" wrote in message> news:E4A=5B93E-6A03-4406-87B6-399E4A150D02@.microsoft.com...> =; Hi Alex> > This is indicating that the =remote connections setting are not set on> the> =protocols. What does the SQLServer 2005 Configuration Manager tool say> (i.e.> not SAC!). Also make sure that you can =resolve the server name> correctly.> > You may =also want to look at SQLPing to to see to search for servers> =http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx=> > John> > "Alex AU" wrote:> > > Dear =John,> >> > I've tried sqlcmd, it also failed. The =command I used and error as> follow:> =>> > sqlcmd -S SERVER\SQL2005> =>> > HResult 0xFFFFFFFF, Level 16, State 1> > =SQL Network Interfaces: Error Locating Server/Instance Specified> > [xFFFFFFFF].> => Sqlcmd: Error: Microsoft SQL Native Client : An error has =occurred> while> > establi> > shing =a connection to the server. When connecting to SQL Server 2005,> this> > failu> > re may be =caused by the fact that under the default settings SQL> Server> > does not> => allow remote connections..> > Sqlcmd: Error: Microsoft =SQL Native Client : Login timeout expired.> >> > Thanks a lot.> >> >> =>> > Regards,> >> > Alex AU> >> > "John =Bell" wrote in message> > news:342=A5195-A4E1-4477-AFDF-F592B3809BDC@.microsoft.com...> =; > Hi Alex> >> > And SQLCMD allows you to connect?> = >> > John> >> > "Alex AU" =wrote:> >> > > Dear =John,> > >> > > I've =already setup the remote connections to accept namepine and> tcpip> > > connection in the =surface area configuration tool.> > >> > > I can use ODBC to =establish connection from my workstation to the> => > SERVER\SQL2005 but just cannot register the server in the> = Management> > > Studio on my workstation.> > =>> > > Thanks.> > >> > >> > >> > > Regards,> > >> = > > Alex AU> > > "John Bell" wrote in message> > > news:323=8D38E-5324-49BB-A188-43078C16F3A1@.microsoft.com...> =; > > Hi Alex> => >> > > Can you =conncet to this server using SQLCMD? If not check that> > Remote> > > =Connections have been set in the surface area configuration> =tool.> > >> > => John> > >> > > "Alex AU" wrote:> = > >> > => > Dear all,> > > >> > > > I've =installed SQL2005 on my local machine. And there is> =another> > > SERVER which has install both SQL2000 and =SQL2005. I can use my> local> > > =Management Studio to register the SERVER\SQL2000 instance but I> cannot> > > register =SERVER\SQL2005 instance.> > > >> > > > How =can I register and connect to the SERVER\SQL2005 server?> = > > >> => > > The SERVER\SQL2005 has been configured to enable =the protocols> of> > > shared =memory, namepipe and tcpip already.> > > >> > => > The SERVER has installed SQL2000 first and then install> SQL2005> > > =server.> > > >> => > > Thanks a lot.> => > >> > => >> > > >> > > > Regards,> > > >> > > > Alex AU> > >> >>

--=_NextPart_000_000F_01C6AF97.8BFAF4C0--|||Here is another one: http://www.sqlserver2005.de > Screencasts > Enable
Remote Connections.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Hi Jens
You may want to add a new screen cast for enabling the XP firewall to allow
SQL Server traffic as described in the lower half of the link Alex provided!
John
"Jens" wrote:
> Here is another one: http://www.sqlserver2005.de > Screencasts > Enable
> Remote Connections.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Sunday, March 25, 2012

Cannot rebuild full text catalogs

Recently moved database and full text catalogs to new server with SQL Server
2000 sp3a/SBS 2003 sp1
I am having problems rebuilding and repopulating the fulltext catalogs
restored to the new server.
The message I encounter is "Error 7635: The Microsoft Search cannot be
administered under the present user account".
I understand from the link I have been referred to
"http://support.microsoft.com/default.aspx?scid=kb;en-us;277549" states that
the service logon was changed through the control panel instead of the
Enterprise Manager therefore the service login for SQL Server does not have
administrative priviledges over the MSSearch service.
None of the service logins were changed through the control panel
I have tried the workround as suggested in the link but I still get the same
error message when I try to rebuild the full text catalog.
Any of you MVP's with another approach or suggestions to solve this problem?What account is MSSearch running under? It must be running under the local
system account. If it is not change it, you can change it through the
services applet in Control panel - Administrative Tasks.
Check that the builtin\Admins group is in the sysadmin role, and if not do
the following
use master
go
exec sp_grantlogin N'NT Authority\System'
exec sp_defaultdb N'NT Authority\System', N'master'
exec sp_defaultlanguage N'NT Authority\System','us_english'
exec sp_addsrvrolemember N'NT Authority\System', sysadmin
goThen change the SQL Server account to a the local system account in
Enterprise manger, right click on it and select properties and then select
the security tab and make the modifcation here, bounce it and the repeat the
process to have it run under a local adminstrators account.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jarvis Allen" <JarvisAllen@.discussions.microsoft.com> wrote in message
news:DA108BC7-E94F-4391-A71F-505CF6D42E0A@.microsoft.com...
> Recently moved database and full text catalogs to new server with SQL
> Server
> 2000 sp3a/SBS 2003 sp1
> I am having problems rebuilding and repopulating the fulltext catalogs
> restored to the new server.
> The message I encounter is "Error 7635: The Microsoft Search cannot be
> administered under the present user account".
> I understand from the link I have been referred to
> "http://support.microsoft.com/default.aspx?scid=kb;en-us;277549" states
> that
> the service logon was changed through the control panel instead of the
> Enterprise Manager therefore the service login for SQL Server does not
> have
> administrative priviledges over the MSSearch service.
> None of the service logins were changed through the control panel
> I have tried the workround as suggested in the link but I still get the
> same
> error message when I try to rebuild the full text catalog.
> Any of you MVP's with another approach or suggestions to solve this
> problem?|||"Hilary Cotter" wrote:
> What account is MSSearch running under? It must be running under the local
> system account. If it is not change it, you can change it through the
> services applet in Control panel - Administrative Tasks.
> Check that the builtin\Admins group is in the sysadmin role, and if not do
> the following
> use master
> go
> exec sp_grantlogin N'NT Authority\System'
> exec sp_defaultdb N'NT Authority\System', N'master'
> exec sp_defaultlanguage N'NT Authority\System','us_english'
> exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> goThen change the SQL Server account to a the local system account in
> Enterprise manger, right click on it and select properties and then select
> the security tab and make the modifcation here, bounce it and the repeat the
> process to have it run under a local adminstrators account.
>
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Jarvis Allen" <JarvisAllen@.discussions.microsoft.com> wrote in message
> news:DA108BC7-E94F-4391-A71F-505CF6D42E0A@.microsoft.com...
> > Recently moved database and full text catalogs to new server with SQL
> > Server
> > 2000 sp3a/SBS 2003 sp1
> > I am having problems rebuilding and repopulating the fulltext catalogs
> > restored to the new server.
> > The message I encounter is "Error 7635: The Microsoft Search cannot be
> > administered under the present user account".
> >
> > I understand from the link I have been referred to
> > "http://support.microsoft.com/default.aspx?scid=kb;en-us;277549" states
> > that
> > the service logon was changed through the control panel instead of the
> > Enterprise Manager therefore the service login for SQL Server does not
> > have
> > administrative priviledges over the MSSearch service.
> > None of the service logins were changed through the control panel
> >
> > I have tried the workround as suggested in the link but I still get the
> > same
> > error message when I try to rebuild the full text catalog.
> >
> > Any of you MVP's with another approach or suggestions to solve this
> > problem?
> Thank you for your reply Hilary
The MS Search service is using the local system logon and built in admin has
the role of sydadmin.
I followed your instructions which was similiar to the instruction I
followed in the link i was reffered to inmy original message.
Unfortunately the your instructions I followed failed to cure the 7635 error
(cannot administer MS Search service under present user account).
Are ther any other slutions to try?
>|||"Jarvis Allen" wrote:
I have tried suggestions by Hilary and the problem still persists.
The MS Search is running under the local system account as it should which
seems to be the problem.
The problem seems to be getting the administer rights over the MS Search
service.
The SQL Server does start with the Domain Admin user.
For some reason the Domain Admin user can administer the MS Search service
even though I have used the suggested way to gain admin rights over the MS
Search!
Any other ideas from you SQL experts?
>
> "Hilary Cotter" wrote:
> > What account is MSSearch running under? It must be running under the local
> > system account. If it is not change it, you can change it through the
> > services applet in Control panel - Administrative Tasks.
> >
> > Check that the builtin\Admins group is in the sysadmin role, and if not do
> > the following
> >
> > use master
> > go
> > exec sp_grantlogin N'NT Authority\System'
> > exec sp_defaultdb N'NT Authority\System', N'master'
> > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > goThen change the SQL Server account to a the local system account in
> > Enterprise manger, right click on it and select properties and then select
> > the security tab and make the modifcation here, bounce it and the repeat the
> > process to have it run under a local adminstrators account.
> >
> >
> >
> > --
> > Hilary Cotter
> > Director of Text Mining and Database Strategy
> > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> >
> > This posting is my own and doesn't necessarily represent RelevantNoise's
> > positions, strategies or opinions.
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
> >
> >
> > "Jarvis Allen" <JarvisAllen@.discussions.microsoft.com> wrote in message
> > news:DA108BC7-E94F-4391-A71F-505CF6D42E0A@.microsoft.com...
> > > Recently moved database and full text catalogs to new server with SQL
> > > Server
> > > 2000 sp3a/SBS 2003 sp1
> > > I am having problems rebuilding and repopulating the fulltext catalogs
> > > restored to the new server.
> > > The message I encounter is "Error 7635: The Microsoft Search cannot be
> > > administered under the present user account".
> > >
> > > I understand from the link I have been referred to
> > > "http://support.microsoft.com/default.aspx?scid=kb;en-us;277549" states
> > > that
> > > the service logon was changed through the control panel instead of the
> > > Enterprise Manager therefore the service login for SQL Server does not
> > > have
> > > administrative priviledges over the MSSearch service.
> > > None of the service logins were changed through the control panel
> > >
> > > I have tried the workround as suggested in the link but I still get the
> > > same
> > > error message when I try to rebuild the full text catalog.
> > >
> > > Any of you MVP's with another approach or suggestions to solve this
> > > problem?
> >
> > Thank you for your reply Hilary
> The MS Search service is using the local system logon and built in admin has
> the role of sydadmin.
> I followed your instructions which was similiar to the instruction I
> followed in the link i was reffered to inmy original message.
> Unfortunately the your instructions I followed failed to cure the 7635 error
> (cannot administer MS Search service under present user account).
> Are ther any other slutions to try?
> >|||>
> "Jarvis Allen" wrote:
> I have tried suggestions by Hilary and the problem still persists.
> The MS Search is running under the local system account as it should which
> seems to be the problem.
> The problem seems to be getting the administer rights over the MS Search
> service.
> The SQL Server does start with the Domain Admin user.
> For some reason the Domain Admin user cannot administer the MS Search service
> even though I have used the suggested way to gain admin rights over the MS
> Search!
> Any other ideas from you SQL experts?
> >
> >
> > "Hilary Cotter" wrote:
> >
> > > What account is MSSearch running under? It must be running under the local
> > > system account. If it is not change it, you can change it through the
> > > services applet in Control panel - Administrative Tasks.
> > >
> > > Check that the builtin\Admins group is in the sysadmin role, and if not do
> > > the following
> > >
> > > use master
> > > go
> > > exec sp_grantlogin N'NT Authority\System'
> > > exec sp_defaultdb N'NT Authority\System', N'master'
> > > exec sp_defaultlanguage N'NT Authority\System','us_english'
> > > exec sp_addsrvrolemember N'NT Authority\System', sysadmin
> > > goThen change the SQL Server account to a the local system account in
> > > Enterprise manger, right click on it and select properties and then select
> > > the security tab and make the modifcation here, bounce it and the repeat the
> > > process to have it run under a local adminstrators account.
> > >
> > >
> > >
> > > --
> > > Hilary Cotter
> > > Director of Text Mining and Database Strategy
> > > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> > >
> > > This posting is my own and doesn't necessarily represent RelevantNoise's
> > > positions, strategies or opinions.
> > >
> > > Looking for a SQL Server replication book?
> > > http://www.nwsu.com/0974973602.html
> > >
> > > Looking for a FAQ on Indexing Services/SQL FTS
> > > http://www.indexserverfaq.com
> > >
> > >
> > >
> > > "Jarvis Allen" <JarvisAllen@.discussions.microsoft.com> wrote in message
> > > news:DA108BC7-E94F-4391-A71F-505CF6D42E0A@.microsoft.com...
> > > > Recently moved database and full text catalogs to new server with SQL
> > > > Server
> > > > 2000 sp3a/SBS 2003 sp1
> > > > I am having problems rebuilding and repopulating the fulltext catalogs
> > > > restored to the new server.
> > > > The message I encounter is "Error 7635: The Microsoft Search cannot be
> > > > administered under the present user account".
> > > >
> > > > I understand from the link I have been referred to
> > > > "http://support.microsoft.com/default.aspx?scid=kb;en-us;277549" states
> > > > that
> > > > the service logon was changed through the control panel instead of the
> > > > Enterprise Manager therefore the service login for SQL Server does not
> > > > have
> > > > administrative priviledges over the MSSearch service.
> > > > None of the service logins were changed through the control panel
> > > >
> > > > I have tried the workround as suggested in the link but I still get the
> > > > same
> > > > error message when I try to rebuild the full text catalog.
> > > >
> > > > Any of you MVP's with another approach or suggestions to solve this
> > > > problem?
> > >
> > > Thank you for your reply Hilary
> > The MS Search service is using the local system logon and built in admin has
> > the role of sydadmin.
> > I followed your instructions which was similiar to the instruction I
> > followed in the link i was reffered to inmy original message.
> > Unfortunately the your instructions I followed failed to cure the 7635 error
> > (cannot administer MS Search service under present user account).
> > Are ther any other slutions to try?
> > >

Cannot rebuild full text catalogs

Saturday, February 25, 2012

Cannot Install DB

Hi,
I have installed the latest MSDE and am entering the following text in the
query analyzer:
EXEC sp_attach_db @.dbname = 'SRPA',
@.filename1 = '{c:\SRPA\SRPA.MDF}',
@.filename2 = '{c:\SPRA\SRPA.LDF}';
but i'm getting the following error:
Error: Device activation error. The physical file name 'c:\SRPA\SRPA.MDF'
may be incorrect.
I have checked and double checked the name/location etc and it all matches..
any help would be greatly appreciated, Thanks
Matt
You dont need these curly brackets. Just type in (as filename is expecting
a nvarchar)
EXEC sp_attach_db @.dbname = 'SRPA',
@.filename1 = N'c:\SRPA\SRPA.MDF',
@.filename2 = N'c:\SPRA\SRPA.LDF'
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
news:C7340567-DD95-4534-A75E-0583F630E6E0@.microsoft.com...
> Hi,
> I have installed the latest MSDE and am entering the following text in the
> query analyzer:
> EXEC sp_attach_db @.dbname = 'SRPA',
> @.filename1 = '{c:\SRPA\SRPA.MDF}',
> @.filename2 = '{c:\SPRA\SRPA.LDF}';
> but i'm getting the following error:
> Error: Device activation error. The physical file name 'c:\SRPA\SRPA.MDF'
> may be incorrect.
> I have checked and double checked the name/location etc and it all
> matches..
> any help would be greatly appreciated, Thanks
> Matt
>
|||Thanks, Tried it but still the same error.
"Jens Sü?meyer" wrote:

> You don′t need these curly brackets. Just type in (as filename is expecting
> a nvarchar)
> EXEC sp_attach_db @.dbname = 'SRPA',
> @.filename1 = N'c:\SRPA\SRPA.MDF',
> @.filename2 = N'c:\SPRA\SRPA.LDF'
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:C7340567-DD95-4534-A75E-0583F630E6E0@.microsoft.com...
>
>
|||Just a moment, i saw that you are using the QA ?!
So perhaps you are not connected to the MSDE rathjer than to a SQL Server.
If you issue the command
sp_Attach_db the SQL Server / MSDE will always look on Local drives to get
control over the datafile. So if you are connected to a remote server rather
than to the MSDE it will tell you that the files are not present.
If you really want to make sure that you are working on the MSDE, just do
this on the command line:
OSQL -E (if you are using Integrated Security, if not
use -UUsername -PPassword)
Then type in the Command i gave you in the last post, that should really
help, if not there MUST be a difference in the location you specified.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
"Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0206A4CE-541A-4CA8-B5A6-5213E982D1EC@.microsoft.com...[vbcol=seagreen]
> Thanks, Tried it but still the same error.
>
> "Jens Smeyer" wrote:
|||Thats got it..with the OSQL -E it worked fine thru cmd.. Thanks for your help
"Jens Sü?meyer" wrote:

> Just a moment, i saw that you are using the QA ?!
> So perhaps you are not connected to the MSDE rathjer than to a SQL Server.
> If you issue the command
> sp_Attach_db the SQL Server / MSDE will always look on Local drives to get
> control over the datafile. So if you are connected to a remote server rather
> than to the MSDE it will tell you that the files are not present.
> If you really want to make sure that you are working on the MSDE, just do
> this on the command line:
> OSQL -E (if you are using Integrated Security, if not
> use -UUsername -PPassword)
> Then type in the Command i gave you in the last post, that should really
> help, if not there MUST be a difference in the location you specified.
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Matt" <Matt@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:0206A4CE-541A-4CA8-B5A6-5213E982D1EC@.microsoft.com...
>
>

Sunday, February 19, 2012

Cannot Import from Filemaker !

Hi all,
I am trying to import data from Filemaker Pro 5 database into SQL Server
2000 using DTS.
The problem is that big text columns are truncated to 255 chars.
Despite I use ntext or text or nvarchar(4000) in destination table, datas
are systematically truncated.
What hapens ?
Please help !
EricIt sounds rather like this problem but this problem has text files. Can you
workaround in a similar fashion ?
DataPump truncates delimited fields to 255 characters
(http://www.sqldts.com/default.aspx?297)
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Eric" <tritet@.free.fr> wrote in message
news:bo604k$6ks$1@.reader1.imaginet.fr...
> Hi all,
> I am trying to import data from Filemaker Pro 5 database into SQL Server
> 2000 using DTS.
> The problem is that big text columns are truncated to 255 chars.
> Despite I use ntext or text or nvarchar(4000) in destination table, datas
> are systematically truncated.
> What hapens ?
> Please help !
> Eric
>
>|||The problem is still there after installing SP3 for Sql server.
The problem is that I want to import data from Filemaker to sql server.
It is an import action, not export as related in this Bug report :
247527 FIX: DTS May Truncate Characters When You Export a Table Column of
Character Data Type to a Text File
Occurs only with strings that are over 255 in length under certain
conditions.
Corrected in SQL Server 2000 SP2.
"Allan Mitchell" <allan@.no-spam.sqldts.com> a écrit dans le message de
news:u2Dkr$ioDHA.2416@.TK2MSFTNGP10.phx.gbl...
> It sounds rather like this problem but this problem has text files. Can
you
> workaround in a similar fashion ?
> DataPump truncates delimited fields to 255 characters
> (http://www.sqldts.com/default.aspx?297)
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> "Eric" <tritet@.free.fr> wrote in message
> news:bo604k$6ks$1@.reader1.imaginet.fr...
> > Hi all,
> >
> > I am trying to import data from Filemaker Pro 5 database into SQL Server
> > 2000 using DTS.
> >
> > The problem is that big text columns are truncated to 255 chars.
> >
> > Despite I use ntext or text or nvarchar(4000) in destination table,
datas
> > are systematically truncated.
> >
> > What hapens ?
> >
> > Please help !
> >
> > Eric
> >
> >
> >
>

Thursday, February 16, 2012

Cannot get results for some search terms (with ampersand or dot

I am having problems doing a "Full Text Search" on the MSSQL2005 database
server for some search terms (those that have a dot or ampersand).
There are no problems doing FTS search with "normal" words.
We're using Microsoft SQL Server Standard Edition, version 9.00.2047.00
Build 3790: Service Pack 1.
The database and tables were created from scratch (not migrated).
Example terms which do not bring back any results...
F&C
P&O
S&P
E.On
Here is an example query:
SELECT TOP 10 *
FROM Content
WHERE where CONTAINS(text_content,'F&C')
Tried escaping the term, putting quotes and replacing the ampersand with &
When doing the search with LIKE I get the results
SELECT TOP 10 *
FROM Content
WHERE where text_content LIKE '%F&C%'
Thanks
Bimal
Bimal wrote on Fri, 2 Mar 2007 00:57:03 -0800:

> I am having problems doing a "Full Text Search" on the MSSQL2005 database
> server for some search terms (those that have a dot or ampersand).
> There are no problems doing FTS search with "normal" words.
> We're using Microsoft SQL Server Standard Edition, version 9.00.2047.00
> Build 3790: Service Pack 1.
> The database and tables were created from scratch (not migrated).
> Example terms which do not bring back any results...
> F&C
> P&O
> S&P
> E.On
> Here is an example query:
> SELECT TOP 10 *
> FROM Content
> WHERE where CONTAINS(text_content,'F&C')
> Tried escaping the term, putting quotes and replacing the ampersand with
> &
> When doing the search with LIKE I get the results
> SELECT TOP 10 *
> FROM Content
> WHERE where text_content LIKE '%F&C%'
When FTS indexes your column, F&C will be broken up to two words - 'F', and
'C'. By default the noise word file contains all single letters, so these
are ignored in the indexing. That's why you won't find them.
There are some workarounds. Edit the noise word file for the language you
are using, and leave just a single space in it. Then run a full population -
this will allow FTS to index everything. You can then use the phrasing
searches to help find the entries, but it still may not always be exact, eg.
SELECT TOP 10 *
FROM Content
WHERE where CONTAINS(text_content,'"F&C"')
would find all rows where text_content has the following:
F&C
F.C
F C
etc.
The only way to get an exact match would be use LIKE (as you've found), to
use text replacement (eg. F&C becomes FANDC in your table, and you do the
same substitution in your query), or to write your own wordbreaker to handle
these the way you want them to (eg. drop & when it's surrounded by spaces,
but leave it when it's touching another character). The first option is the
simplest, the last option the most complex.
Dan
|||Thanks for that detailed reply - fyi, we've chosen to treat words (so A&C
becomes AXXNDXXB) but i'm not happy that we have this workaround.
Do you know why the indexer treats the term "F&C" as individual characters
(so it really thinks you've entered F & C) and so excludes these from being
indexed?
I would be interested to know what Microsoft's official response is on this
(whether they plan on improving the word breaker), I do think it should treat
terms like F&C or E.On (all valid company names) as words and not individual
characters.
Thanks
Bimal
"Daniel Crichton" wrote:

> Bimal wrote on Fri, 2 Mar 2007 00:57:03 -0800:
>
> When FTS indexes your column, F&C will be broken up to two words - 'F', and
> 'C'. By default the noise word file contains all single letters, so these
> are ignored in the indexing. That's why you won't find them.
> There are some workarounds. Edit the noise word file for the language you
> are using, and leave just a single space in it. Then run a full population -
> this will allow FTS to index everything. You can then use the phrasing
> searches to help find the entries, but it still may not always be exact, eg.
> SELECT TOP 10 *
> FROM Content
> WHERE where CONTAINS(text_content,'"F&C"')
> would find all rows where text_content has the following:
> F&C
> F.C
> F C
> etc.
> The only way to get an exact match would be use LIKE (as you've found), to
> use text replacement (eg. F&C becomes FANDC in your table, and you do the
> same substitution in your query), or to write your own wordbreaker to handle
> these the way you want them to (eg. drop & when it's surrounded by spaces,
> but leave it when it's touching another character). The first option is the
> simplest, the last option the most complex.
> Dan
>
>

Tuesday, March 27, 2012

Cannot Register Remote Server

Sunday, March 25, 2012

Cannot rebuild full text catalogs

Cannot rebuild full text catalogs

Cannot rebuild full text catalogs

Saturday, February 25, 2012

Cannot Install DB

Sunday, February 19, 2012

Cannot Import from Filemaker !

Thursday, February 16, 2012

Cannot get results for some search terms (with ampersand or dot

Cannot find mdf files

Blog Archive

About Me