Receiving Error 26 when trying to connect to DB...Some Machines

Good Day,

We have a recently developed (and in testing) VB .Net application which attaches to a specific SQL2005 DB. The issue is that when installed (or run in DEBUG mode) on the developer box it successfully connects to the appropriate db locally and to the live server. When installed on a test box (several of them) we receive error - 26 Error locating Server/Instance Specified.

The SQL Server instance is set up for remote connections and works for other dbs.

All of the boxes are running XP Pro, with all SPs applied.

Any thoughts on what may be occuring would be greatly appreciated.

This might help:
"Connection error occurs when the Database Engine service account password expires

The

following error occurs when you connect to a report server, and the

service account password has expired for the SQL Server Database Engine

instance that hosts the report server database: "The report server

cannot open a connection to the report server database. A connection to

the database is required for all requests and processing.

(rsReportServerDatabaseUnavailable)."

The error message includes

these additional statements: "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. (provider: SQL Server Network

Interfaces, error: 26 - Error Locating Server/Instance Specified)."

To resolve this error, reset the password. For more information, see Changing Passwords and User Accounts."

http://msdn2.microsoft.com/en-us/library/ms156468.aspx

Also check out this kb:
http://support.microsoft.com/kb/905618

Receiving a message with a specific contract

If the service is defined with multiple contracts is there a way to receive a message with a specific contract?

No. I'm curious to understand why do you want this, can you give a bit of detail?

Thanks,
~ Remus

|||

I am implementing a queue processing system. You can get some of the info here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=446600&SiteID=1. The queue can contain messages of different contracts/types. When I receive a message I instantiate a different processing component based on the contract/type of the message. There are processing servers that process different kind of messages. The single processing server might only have a subset of processing components. This is why I need a way to retrieve messages based on the contract/type.

Alex

|||

You can try having one service as front end that simply forwards each dialog to specialized services on the back end, similar to the approach described here: https://blogs.msdn.com/remusrusanu/archive/2006/03/28/563571.aspx

Each supported contract would be forwarded to a different service.

HTH,
~ Remus

|||

I have a working implementation without Service Broker which handles message types and message priority (another one Service Broker does not handle directly). It does not make sence to switch to Service Broker which would also require to increse the complexity of the architecture.

Alex

Receiving "Error: 18456" when for a specific user who has rights via AD Group

I have a user who is a domain admin and has rights based on a group
policy (OURDOMAIN\Developers) to access the SQL Server. He can access
other Sql Servers, and every other member of the group can access all
boxes. So its a case of a specific users cannot access a specific
box. Below is the error message he is getting:
TITLE: Connect to Server
--
Cannot connect to SQLDEV1.
--
ADDITIONAL INFORMATION:
Login failed for user 'OURDOMAIN\user'. (Microsoft SQL Server, Error:
18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
--
BUTTONS:
OK
--
SQL2005 Ent SP1 on Win03
Any ideas would be appreciated.Hi
"Keeper of the Bits" wrote:
> I have a user who is a domain admin and has rights based on a group
> policy (OURDOMAIN\Developers) to access the SQL Server. He can access
> other Sql Servers, and every other member of the group can access all
> boxes. So its a case of a specific users cannot access a specific
> box. Below is the error message he is getting:
>
> TITLE: Connect to Server
> --
> Cannot connect to SQLDEV1.
> --
> ADDITIONAL INFORMATION:
> Login failed for user 'OURDOMAIN\user'. (Microsoft SQL Server, Error:
> 18456)
> For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
> --
> BUTTONS:
> OK
> --
>
>
> SQL2005 Ent SP1 on Win03
> Any ideas would be appreciated.
>
Maybe you are seeing http://support.microsoft.com/kb/925744/en-us I believe
3152 is the latest version you can download if you want to move past SP2.
John|||You can more details about login failures from the SQL
Server error log on SQL Server 2005. Check the log for the
State - there will be a line similar to:
Logon Error: 18456, Severity: 14, State:18
Then check the corresponding description for that state in
the following article:
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
-Sue
On 13 Apr 2007 12:06:22 -0700, "Keeper of the Bits"
<styree@.creditsolutions.com> wrote:
>I have a user who is a domain admin and has rights based on a group
>policy (OURDOMAIN\Developers) to access the SQL Server. He can access
>other Sql Servers, and every other member of the group can access all
>boxes. So its a case of a specific users cannot access a specific
>box. Below is the error message he is getting:
>
>TITLE: Connect to Server
>--
>Cannot connect to SQLDEV1.
>--
>ADDITIONAL INFORMATION:
>Login failed for user 'OURDOMAIN\user'. (Microsoft SQL Server, Error:
>18456)
>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
>--
>BUTTONS:
>OK
>--
>
>
>SQL2005 Ent SP1 on Win03
>Any ideas would be appreciated.

Receive mail when specific user connects

Hi,
I want to receive a mail when a specific user connects.
How can this be done best? Raise an alert? How?
Btw, the 'Login auditing' is set to 'Failed logins only'.
Suggestions are very welcome!
Cheers,
Eu can scan master..sysprocesses table periodacally to check if that user has connected by matching sid with sid of syslogins table. a job can send u the mail, if not as soon as the user connects (depends on the frequency of the job) ... there might be a better option not sure...

rebuilding full text indexes

Aight, so I added a full text catalog and a full text index for one specific column and table in my database.

Now the issue is, whenever I rebuild it, it locks the full text index forever, making it unsuable. Now, there are only 30,000 records i need to search, so it isn't like there is this massive amount of data. What am I doing wrong to where it is locking the index and disallowing me to use the stored procedure that does the searching?

The indexes have changed in SQL Server 2005 but it places locks on the table or column during rebuilds that is the reason to schedule the now discontinued index related DBCC statements to run at night or when ever is a slow time for your users. There are some access restrictions during rebuild so, you may want to plan and use the new tuning advisor. In previous versions I know if needed you can count the IAM (index allocation mapping) pages and Extents so you can prevent related performance issues. Try the link below for the new index rebuild information. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms188388.aspx

|||

today we got a messagge like full text index is corrupt.Do u know why does this happen?

PS: we did send TRUNCATE TABLE COMMAND to the table that had the index...is it a problem?

sql

Rebuild all the indexes ?

Can anyone let me know like we need to rebuild all the indexes of all tables
every day? or the specific indexes?
Thanks
But be careful, its an undocumented feature:
EXEC sp_MSforeachtable @.command1="print '?' DBCC DBREINDEX ('?')"
DBCC DBREINDEX
( 'database.owner.table_name'
[ , index_name
[ , fillfactor ]
]
) [ WITH NO_INFOMSGS ]
Arguments
For a specifix table --> BOL
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:%23hb$TBRRFHA.3672@.TK2MSFTNGP10.phx.gbl...
> Can anyone let me know like we need to rebuild all the indexes of all
> tables
> every day? or the specific indexes?
> Thanks
>
|||my question is that we need to reubuild daily basis or not?
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:#e1q6FRRFHA.3156@.TK2MSFTNGP15.phx.gbl...
> But be careful, its an undocumented feature:
> EXEC sp_MSforeachtable @.command1="print '?' DBCC DBREINDEX ('?')"
>
> DBCC DBREINDEX
> ( 'database.owner.table_name'
> [ , index_name
> [ , fillfactor ]
> ]
> ) [ WITH NO_INFOMSGS ]
> Arguments
> For a specifix table --> BOL
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:%23hb$TBRRFHA.3672@.TK2MSFTNGP10.phx.gbl...
>
|||Please see this whitepaper
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Joh" <joh@.mailcity.com> wrote in message
news:uCjtKIRRFHA.1528@.TK2MSFTNGP09.phx.gbl...
> my question is that we need to reubuild daily basis or not?
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:#e1q6FRRFHA.3156@.TK2MSFTNGP15.phx.gbl...
>

re-associate "dbo" user with "sa" login

Once "dbo" user on a particular db has been associated with a specific login
( "Login1") , how to re-associate it with its default login ( "sa" ) ?
My ultimate goal is to add user "User1" to this db and associate it with
login "Login1" . but to do that apparently I need to de-associate "Login1"
login from "dbo" user.It sounds like the user is the database owner. You can
change the owner to sa by executing the following in the
database:
exec sp_changedbowner 'sa'
-Sue
On Thu, 27 Jul 2006 11:15:59 -0700, "John A Grandy"
<johnagrandy-at-yahoo-dot-com> wrote:

>Once "dbo" user on a particular db has been associated with a specific logi
n
>( "Login1") , how to re-associate it with its default login ( "sa" ) ?
>My ultimate goal is to add user "User1" to this db and associate it with
>login "Login1" . but to do that apparently I need to de-associate "Login1"
>login from "dbo" user.
>

Reassigning or Assigning DBID

I have someone who wants to assign a specific DBID to a database. For
example, he wants a database named 'duplicate' to be dbid '20'. Is this
possible? If so, how can it be done?
Nathan
I don't believe it's possible but what possible reason could he have for
wanting that? You don't want to build a dependence on a DBID into your
application. Tell him to forget it is my advice!
David Portas
SQL Server MVP
|||I totally agree with David on this one, what possible reason is there for
this ? For the sake of it though, you just need 19 databases and the next
one is 20. If you have more than 19 already then detach the one that has
dbid =20 and create/attach the database and voila it has dbid=20. Again,
this seems fairly pointless...
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<none@.nnn.com> wrote in message
news:OVRkG2sNEHA.2704@.TK2MSFTNGP10.phx.gbl...
> I have someone who wants to assign a specific DBID to a database. For
> example, he wants a database named 'duplicate' to be dbid '20'. Is this
> possible? If so, how can it be done?
> Nathan
>

Reassigning or Assigning DBID

I have someone who wants to assign a specific DBID to a database. For
example, he wants a database named 'duplicate' to be dbid '20'. Is this
possible? If so, how can it be done?
NathanI don't believe it's possible but what possible reason could he have for
wanting that? You don't want to build a dependence on a DBID into your
application. Tell him to forget it is my advice!
--
David Portas
SQL Server MVP
--|||I totally agree with David on this one, what possible reason is there for
this ? For the sake of it though, you just need 19 databases and the next
one is 20. If you have more than 19 already then detach the one that has
dbid =20 and create/attach the database and voila it has dbid=20. Again,
this seems fairly pointless...
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<none@.nnn.com> wrote in message
news:OVRkG2sNEHA.2704@.TK2MSFTNGP10.phx.gbl...
> I have someone who wants to assign a specific DBID to a database. For
> example, he wants a database named 'duplicate' to be dbid '20'. Is this
> possible? If so, how can it be done?
> Nathan
>

Reassigning or Assigning DBID

I have someone who wants to assign a specific DBID to a database. For
example, he wants a database named 'duplicate' to be dbid '20'. Is this
possible? If so, how can it be done?
NathanI don't believe it's possible but what possible reason could he have for
wanting that? You don't want to build a dependence on a DBID into your
application. Tell him to forget it is my advice!
David Portas
SQL Server MVP
--|||I totally agree with David on this one, what possible reason is there for
this ? For the sake of it though, you just need 19 databases and the next
one is 20. If you have more than 19 already then detach the one that has
dbid =20 and create/attach the database and voila it has dbid=20. Again,
this seems fairly pointless...
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<none@.nnn.com> wrote in message
news:OVRkG2sNEHA.2704@.TK2MSFTNGP10.phx.gbl...
> I have someone who wants to assign a specific DBID to a database. For
> example, he wants a database named 'duplicate' to be dbid '20'. Is this
> possible? If so, how can it be done?
> Nathan
>