I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happened to my database?
You probably have a Antivirus software scanning the database file and the system is unable to get a lock on the file.|||I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting? because my table size is 4.5G .

thx|||You can download Filemon from sysinternals.com.

During 'auto growth', the database will be locked but that doesn't sound like the problem you're encountering.|||The problem still occurred in sql server log. I don't know what happen with that table. it is a 40G database and what can i do with this error?sql

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happened to my database?
You probably have a Antivirus software scanning the database file and the system is unable to get a lock on the file.|||I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting? because my table size is 4.5G .

thx|||You can download Filemon from sysinternals.com.

During 'auto growth', the database will be locked but that doesn't sound like the problem you're encountering.|||The problem still occurred in sql server log. I don't know what happen with that table. it is a 40G database and what can i do with this error?

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happened to my database?
You probably have a Antivirus software scanning the database file and the system is unable to get a lock on the file.|||I cannot remind if there was another processing locking the file, what command I can use to check, is it related to the "auto growth" setting? because my table size is 4.5G .

thx|||You can download Filemon from sysinternals.com.

During 'auto growth', the database will be locked but that doesn't sound like the problem you're encountering.|||The problem still occurred in sql server log. I don't know what happen with that table. it is a 40G database and what can i do with this error?

I got the following error: Error: 823, Severity: 24, State: 4 I/O error 33

I got the following error

Error: 823, Severity: 24, State: 4

I/O error 33(The process cannot access the file because another process

has locked a portion of the file.) detected during write at offset

0x0000000a796000 in file xxxxxxxxx.mdf'.

What happend with my database?

Hello,

How are you acessing the DB?

Do you have 2 Destinations pointing to the same DB file?

Is that error in the SSIS?

Regards,

I fixed it but want to confirm my solution

Hi Everyone,
I installed MSDE and created some VB.Net apps that worked. However,
when I tried to access them over a peer to peer LAN, I kept getting ..
"Server does not exist or access denied."
I researched the newsgroups and learned about ...
SVRNETCN.exe - Server Network configuration utility.
I launched the tool and saw that nothing was enabled. I enabled TCP/IP,
then stopped and restarted the SQL services and it now seems to work.
Questions:
- I read about 'named pipes' too and I'm wondering if I have to enable
them too (I have no idea what named pipes are)
- I enabled just the TCP/IP protocol and didn't poke around anywhere
else. Is this sufficient? Or should I verify anything else?
(I might have to ask this in another newsgroup but I'll try...)
In my search to fix the problem, I came across many messages about "Code
Access Security Policy" and I started reading about .Net Configuration
utility with its runtime security policies (code groups, permission
sets, policy assemblies) and I was trying things in there. Is there
anything that MSDE or VB.Net apps need changed in there?
Thanks for your help
Richard
You would only need to enable named pipes if you had clients connecting to
your MSDE instance that had named pipes as the default protocol.
Having only TCP/IP enabled is ok as long as any client connections are also
using TCP/IP.
Jim
"Richard Fagen" <no_spam@.my_isp.com> wrote in message
news:uaP0NIPGEHA.3372@.TK2MSFTNGP09.phx.gbl...
> Hi Everyone,
> I installed MSDE and created some VB.Net apps that worked. However,
> when I tried to access them over a peer to peer LAN, I kept getting ..
> "Server does not exist or access denied."
> I researched the newsgroups and learned about ...
> SVRNETCN.exe - Server Network configuration utility.
> I launched the tool and saw that nothing was enabled. I enabled TCP/IP,
> then stopped and restarted the SQL services and it now seems to work.
> Questions:
> - I read about 'named pipes' too and I'm wondering if I have to enable
> them too (I have no idea what named pipes are)
> - I enabled just the TCP/IP protocol and didn't poke around anywhere
> else. Is this sufficient? Or should I verify anything else?
>
> (I might have to ask this in another newsgroup but I'll try...)
> In my search to fix the problem, I came across many messages about "Code
> Access Security Policy" and I started reading about .Net Configuration
> utility with its runtime security policies (code groups, permission
> sets, policy assemblies) and I was trying things in there. Is there
> anything that MSDE or VB.Net apps need changed in there?
> Thanks for your help
> Richard
sql

I couldn't access the Secondary Database after I finished Shipping Configuration

Dear All

Please I need an urgent help

After i finished all Transaction Log Shipping Configuration.

I tried to use the database in the secondary database but i couldn't access it

i saw it in SQL Managment Studio as (Restoring......)

i tired to make a database snapshot from it , i had a message

Msg 1822, Level 16, State 1, Line 1

The database must be online to have a database snapshot.

Please urgently

the secondary database is in a "Restoring" mode in this case, so you cannot take a snapshot of it. this is by-design.

if you do want take snapshot of the secondary database , you can choose the "standby"
mode when you configure the logshipping secondary db.

HTH.

thanks

Yunwen

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
Pippo
Hi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
PippoFrom what you have said you do not have access rights to
start it.
Can you give me some more details on your set up i.e.
client server, stand alone ect ?
>--Original Message--
>Hi,
>In SQL Server Service Manager, when i start the Sql
>Server Service, the service don't start. There is a An
>error 5 (Access Denied).
>How can resolve it?
>Thank for all
>Pippo
>.
>|||Hi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo|||This service started, and now don't start,
if I start the service from prompt i have I more
descriptions from the errors'
How i can start the service from prompt?
Thank for All
Pippo
>--Original Message--
>From what you have said you do not have access rights to
>start it.
>Can you give me some more details on your set up i.e.
>client server, stand alone ect ?
>
>>--Original Message--
>>Hi,
>>In SQL Server Service Manager, when i start the Sql
>>Server Service, the service don't start. There is a An
>>error 5 (Access Denied).
>>How can resolve it?
>>Thank for all
>>Pippo
>>.
>.
>|||Hi,
To start the default instance of SQL Server from a command prompt
sqlservr.exe -c
To start a named instance of SQL Server
sqlservr.exe -c -s {instancename}
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:19e9b01c41d4d$329947d0$a301280a@.phx.gbl...
> This service started, and now don't start,
> if I start the service from prompt i have I more
> descriptions from the errors'
> How i can start the service from prompt?
> Thank for All
> Pippo
>
> >--Original Message--
> >From what you have said you do not have access rights to
> >start it.
> >
> >Can you give me some more details on your set up i.e.
> >client server, stand alone ect ?
> >
> >
> >>--Original Message--
> >>Hi,
> >>In SQL Server Service Manager, when i start the Sql
> >>Server Service, the service don't start. There is a An
> >>error 5 (Access Denied).
> >>How can resolve it?
> >>
> >>Thank for all
> >>
> >>Pippo
> >>.
> >>
> >.
> >

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
PippoHi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx
.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo

I can't seem to access my fulltext data

I am running on Sql Server 2000.
This was set up a couple of weeks ago and ran fine. I came in today and was
looking at some of my asp.net pages and started to get the error:
Execution of a full-text operation failed. The catalog does not exist or is
currently unavailable
I tried just a simple query:
select * from position where Contains(jobDescription,'sales')
and got the same error.
What causes the problem? When I right-click on the table and go the
fulltext menu and wizard, it says it is already set up for FullText
indexing.
Thanks,
Tom
Can you check for any messages in the event log from MSSearch or MSSCI?
You might also want to use the gthrlog.vbs to examine your gatherer logs for
this catalog.
Go to c:\program files\Common files\system\mssearch\bin copy the gthrlog.vbs
to c:\winnt\system32 directory or add the above path to your
path (control panel - system - Environment - user and in the path variable
append the above path in the path value (separate it from the entry before
with a ;).
Click on set, apply and OK. Run path from the command prompt to ensure you
did this correctly. You may have to close down all dos boxes to get this to
update
correctly, if not a log off log on normally works.
Now navigate to your gather log location. On my machine it is at
C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs>
then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
there.
these logs have time stamps on them, look for a date relevant one to
examine.
Hilary Cotter
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
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:eeSITHLMFHA.3016@.TK2MSFTNGP15.phx.gbl...
> I am running on Sql Server 2000.
> This was set up a couple of weeks ago and ran fine. I came in today and
was
> looking at some of my asp.net pages and started to get the error:
> Execution of a full-text operation failed. The catalog does not exist or
is
> currently unavailable
> I tried just a simple query:
> select * from position where Contains(jobDescription,'sales')
> and got the same error.
> What causes the problem? When I right-click on the table and go the
> fulltext menu and wizard, it says it is already set up for FullText
> indexing.
> Thanks,
> Tom
>
>
|||> Can you check for any messages in the event log from MSSearch or MSSCI?
> You might also want to use the gthrlog.vbs to examine your gatherer logs
> for
> this catalog.
> Go to c:\program files\Common files\system\mssearch\bin copy the
> gthrlog.vbs
> to c:\winnt\system32 directory or add the above path to your
> path (control panel - system - Environment - user and in the path variable
> append the above path in the path value (separate it from the entry before
> with a ;).
> Click on set, apply and OK. Run path from the command prompt to ensure you
> did this correctly. You may have to close down all dos boxes to get this
> to
> update
> correctly, if not a log off log on normally works.
> Now navigate to your gather log location. On my machine it is at
>
> C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs>
>
> then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
> there.
> these logs have time stamps on them, look for a date relevant one to
> examine.
We don't have cscript.vbs on our server which is a "Windows 2003 Server".
But the date of the only file in the GatherLogs folder is 3/15/05 and this
happened today.
There is no entry in the Event log or the Sql Server Logs about this
either - the last entry was 2:00 am this morning for our backups.
However, I did look at the FullTextCatalogs in the Databases folder on EM
and saw that the JobDescriptions Catalog is idle. Is this normal?
Thanks,
Tom
>
> --
> Hilary Cotter
> 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
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:eeSITHLMFHA.3016@.TK2MSFTNGP15.phx.gbl...
> was
> is
>
|||Possibly, can you try to run a full population.
Btw its cscript gthrlog SQL0000600006.7.gthr
My mistake
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:e$rh5NMMFHA.3960@.TK2MSFTNGP12.phx.gbl...
> We don't have cscript.vbs on our server which is a "Windows 2003 Server".
> But the date of the only file in the GatherLogs folder is 3/15/05 and this
> happened today.
> There is no entry in the Event log or the Sql Server Logs about this
> either - the last entry was 2:00 am this morning for our backups.
> However, I did look at the FullTextCatalogs in the Databases folder on EM
> and saw that the JobDescriptions Catalog is idle. Is this normal?
> Thanks,
> Tom
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uiDrhnMMFHA.4044@.TK2MSFTNGP12.phx.gbl...
> Possibly, can you try to run a full population.
I did try the full population, but that didn't seem to help. But when I did
a rebuild catalog and then full population it worked fine.
Why would it do that and how would I get around that?
I can't have people trying to use our site and finding that their searches
won't work.
Thanks,
Tom
> Btw its cscript gthrlog SQL0000600006.7.gthr
> My mistake
>
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e$rh5NMMFHA.3960@.TK2MSFTNGP12.phx.gbl...
>
|||Its hard to say - their may have been some catalog corruption, but there
should have been error messages logged in the event log, or in the gatherer
logs.
Hilary Cotter
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
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:e26H3zMMFHA.3760@.TK2MSFTNGP12.phx.gbl...
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uiDrhnMMFHA.4044@.TK2MSFTNGP12.phx.gbl...
> I did try the full population, but that didn't seem to help. But when I
did[vbcol=seagreen]
> a rebuild catalog and then full population it worked fine.
> Why would it do that and how would I get around that?
> I can't have people trying to use our site and finding that their searches
> won't work.
> Thanks,
> Tom
MSSCI?[vbcol=seagreen]
logs[vbcol=seagreen]
find[vbcol=seagreen]
Server".[vbcol=seagreen]
EM
>
|||Hilary,
I have had a similiar issue; I cannot read any of my data from a simple
query or returning all rows from SQL. I tried to reinstal my *.dll files for
MSSearch, to no avail.
I am running Server 2003, SQL 2000 sp3.
Any help would be appreciated.
Derek
"Hilary Cotter" wrote:

> Its hard to say - their may have been some catalog corruption, but there
> should have been error messages logged in the event log, or in the gatherer
> logs.
> --
> Hilary Cotter
> 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
> "tshad" <tscheiderich@.ftsolutions.com> wrote in message
> news:e26H3zMMFHA.3760@.TK2MSFTNGP12.phx.gbl...
> did
> MSSCI?
> logs
> find
> Server".
> EM
>
>
|||Its difficult to assess what the problem could be. Could you check the event
log from messages coming from MSSearch or MSSCi? This might refer to your
gatherer logs, which can be accessed by using the gthrlog.vbs utility.
go to c:\program files\Common files\system\mssearch\bin, copy the
gthrlog.vbs to c:\winnt\system32 directory or add the above path to your
path (control panel - system - Environment - user and in the path variable
append the above path in the path value (separate it from the entry before
with a ;).
Click on set, apply and OK. Run path from the command prompt to ensure you
did this correctly. You may have to close down all dos boxes to get this to
update
correctly, if not a log off log on normally works.
Now navigate to your gather log location. On my machine it is at C:\Program
Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\XGatherLogs
then type cscript.vbs gthrlog SQL0000600006.7.gthr or whatever you find
there. these logs have time stamps on them, look for a date relevant one
to examine.
The most common reason for such a failure is the the SQL Server Service
account was changed through control panel as opposed to through EM. Refer to
this kb article for more information.
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
Hilary Cotter
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
"dkoz" <dkoz@.discussions.microsoft.com> wrote in message
news:D0FA563F-B9B0-4ABF-887B-DEA64EE7DDE9@.microsoft.com...
> Hilary,
> I have had a similiar issue; I cannot read any of my data from a simple
> query or returning all rows from SQL. I tried to reinstal my *.dll files
for[vbcol=seagreen]
> MSSearch, to no avail.
> I am running Server 2003, SQL 2000 sp3.
> Any help would be appreciated.
> Derek
> "Hilary Cotter" wrote:
gatherer[vbcol=seagreen]
I[vbcol=seagreen]
searches[vbcol=seagreen]
gatherer[vbcol=seagreen]
entry[vbcol=seagreen]
ensure[vbcol=seagreen]
get[vbcol=seagreen]
to[vbcol=seagreen]
and[vbcol=seagreen]
this[vbcol=seagreen]
on[vbcol=seagreen]
today[vbcol=seagreen]
exist[vbcol=seagreen]
the[vbcol=seagreen]
FullText[vbcol=seagreen]

I cant make new SQL Server Registration

When I regratrate, it occurs that
"SQL Server do not exist or access denied
ConnectionOpen(Connect())"
Please suggest me. How I can fix it?Hi, Check the User name and the password.
one more thing ..check whether the sql server is accessible from ur machine or not. use the ping command to check it.

cheers
gola munjal

Originally posted by yajai
When I regratrate, it occurs that

"SQL Server do not exist or access denied
ConnectionOpen(Connect())"

Please suggest me. How I can fix it?|||Make sure to have similar netlibs as default on server and client.
Try connecting with TCP/IP.|||when i ping host, result is

Pinging 216.58.174.179 with 32 bytes of data:

Destination host unreachable.
Destination host unreachable.
Destination host unreachable.
Destination host unreachable.

Ping statistics for 216.58.174.179:
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)

what does it mean?|||How I connect TCP/IP?|||If the PING is not successful then how can you connect?
Take a help of NETWORK Admin to resolve the connectivity first.

Refer to this KBA (http://support.microsoft.com/default.aspx?scid=/support/sql/content/connect/ClientIP.asp) for more information.

i can't connect with the MSDE instance from another computer

I've installed a MSDE in one computer and i can access the
data without problems from the same computer , but if i
try to connect to the MSDE from another computer in the
same network , the instance doesn't appear. I tried from
almost 3 computers but i can't connect.
What i'm doing wrong?
Jorge,
If you installed the latest version the network protocols are probably
disabled (the default setting). Use svrnetcn.exe in the Binn folder under
your sql server directory to enable TCP/IP and things should work again. If
the machine with MSDE has a firewall make sure that the appropriate ports
can pass through the firewall (normally 1433). Use Properties on the
enabled TCP protocol to see the port used.
Ron Allen
"Jorge Lozano" <j.lozano@.initron20.com> wrote in message
news:07f001c49a51$94f2b8e0$a601280a@.phx.gbl...
> I've installed a MSDE in one computer and i can access the
> data without problems from the same computer , but if i
> try to connect to the MSDE from another computer in the
> same network , the instance doesn't appear. I tried from
> almost 3 computers but i can't connect.
> What i'm doing wrong?

I can't add a user in "Security/Logins"

Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:

> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Good morning everyone,
I've a user listed in "Security/Logins".
If I right/click a database, Properties, "Permission" tab, I can't "Add" it
to database's "Users or roles": if I "Browse" for users, it isn't listed. Ho
w
can I add?|||Under Security - Logins, right-click the user and hit properties. (IN
SQL 2000)Go to the database access tab, select the db you want to grant
access to then give the rights below. By default, you only grant
public.
natasha wrote:
> Good morning everyone,
> I've a user listed in "Security/Logins".
> If I right/click a database, Properties, "Permission" tab, I can't "Add" i
t
> to database's "Users or roles": if I "Browse" for users, it isn't listed.
How
> can I add?|||Yes, and in SQL 2005 "database access" tab has been substituted by "User
mapping" tab. But, owner of the database is dbo, and differently from other
DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
Is there any way to force a "take ownership" of the database?
"PSPDBA" ha scritto:

> Under Security - Logins, right-click the user and hit properties. (IN
> SQL 2000)Go to the database access tab, select the db you want to grant
> access to then give the rights below. By default, you only grant
> public.
> natasha wrote:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||Have you tried using the following stored procedure on the database where yo
u
wnat the user to have access to:
EXEC sp_adduser 'loginname', 'username'
See if that works or give any error?
Lucas
"natasha" wrote:
[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>|||> Is there any way to force a "take ownership" of the database?
sp_changedbowner
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"natasha" <natasha@.discussions.microsoft.com> wrote in message
news:FBFC25FE-C6C8-4B8E-A769-419169EF1DDB@.microsoft.com...[vbcol=seagreen]
> Yes, and in SQL 2005 "database access" tab has been substituted by "User
> mapping" tab. But, owner of the database is dbo, and differently from othe
r
> DBs, I can't substitute, even if I am the super-non-plus-ultra-admin.
> Is there any way to force a "take ownership" of the database?
>
> "PSPDBA" ha scritto:
>|||I tried to, and I've quite a curious error:
Msg 15063, Level 16, State 1, Line 1
The login already has an account under a different user name.
"Lucas Kartawidjaja" ha scritto:
[vbcol=seagreen]
> Have you tried using the following stored procedure on the database where
you
> wnat the user to have access to:
> EXEC sp_adduser 'loginname', 'username'
> See if that works or give any error?
> Lucas
> "natasha" wrote:
>sql

I can't access cubes from excel

I try to register the dll in a remote machine but I couldn't.
Do I need to install something else in the remote machine?whats the message / error u r gett5ing. what exactly have u done?"|||The error is Load Library "C:\........................." failed
GetLastError returns 0x00000485
In the client I haven't installed anything. I only copied the dll and try to register it. Should I install something else?
Thanks in advance|||Does anyone has connected with Excel from other computer than the server?
From the server I can connect.
What whould I install in the computer to connect to the server with Excel?
Thanks in advance.|||

Before you can connect from Excel to the Olap 2005 server, you need to install Microsoft OLEDB for Olap 9.0.

The file you need to install is: pts9.msi - Located in
"En_SQL_DEV_x86_ctp_JUNE2005\Redist\Analysis Services\pts9.msi".

Best regards,

Jakobsgaard

|||Yes I have tried this with no luck.
I think is a version problem, my server is April CTP.
I'll try to install client tools in remote client.sql

I can't access a report by URL

Hi every body,
I'm new at using Report Services and I don't understand what I am
supposed to do to access a report by URL.
For the moment, I'm still working on report samples and I try to
create an URL access to Employee Sales Summary. I've made a small web
page with this link:
<a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
Reports/Employee Sales
Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
direct</a>
It accesses the page but asks me for the parameters as if they were
not in the url.
The real goal behind this is to access to the report using a
multiple-values parameter for the Employee ID. As it doesn't seem to
be possible from the basic interface of Report Sevices, I thought I
could make a form and then pass the list in the parameters and making
the "where" clause like this in the report:
where SalesPersonID IN (@.EmpID)You should use the report server URL not the Report Manager URL.
So try this:
http://localhost/reportsever?/Sample&rs:Command=Render
The full documentation on how to do this is available in Books online (also
on MSDN). Search for URL Access.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407190102.cb43a71@.posting.google.com...
> Hi every body,
> I'm new at using Report Services and I don't understand what I am
> supposed to do to access a report by URL.
> For the moment, I'm still working on report samples and I try to
> create an URL access to Employee Sales Summary. I've made a small web
> page with this link:
> <a href="http://links.10026.com/?link=http://localhost/Reports/Pages/Report.aspx?Itempath=/Sample
> Reports/Employee Sales
> Summary&rc:Parameters=false&rs:Command=Render&rs:format=HTML4.0&EmpId=20&ReportYear=2003&ReportMonth=12">lien
> direct</a>
> It accesses the page but asks me for the parameters as if they were
> not in the url.
> The real goal behind this is to access to the report using a
> multiple-values parameter for the Employee ID. As it doesn't seem to
> be possible from the basic interface of Report Sevices, I thought I
> could make a form and then pass the list in the parameters and making
> the "where" clause like this in the report:
> where SalesPersonID IN (@.EmpID)|||Thanks a lot!
It did work :) .
But actually, it was only the first step of my tests and I have now a
new issue.
As I have explained earlier (I think I did...), I need a multi-value
field parameter. This is the only reason why I'm making this html
page.
For the moment, the single value field works but I can't make it with
a multi-value field. It seems that my query is simply not good.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (@.EmpId))
I also tried to test the syntax of the list in the parameter, using
this query:
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN (20,21))
and then I tried
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
WHERE (EmployeeID IN ('20','21'))
The report appears empty (the value 20 and 21 are good and the report
parameter is an integer).
Any Idea of how I should do?|||Jocelyn,
You can't use a variable in an IN clause. You need to use a Function like
the one below and either JOIN to it or use a nested SELECT.
e.g.
SELECT FirstName, MiddleName, LastName, AddressID
FROM Employee
INNER JOIN dbo.fnIntList(@.EmpId) ON EmployeeID=Value
brian
---
CREATE FUNCTION dbo.fnIntList ( @.InputString varchar(2000) )
RETURNS @.IntList TABLE (Value int)
AS
BEGIN
DECLARE @.Temp int
DECLARE @.Delimiter varchar(1)
SET @.Delimiter = ','
-- remove any surrounding spaces
SET @.InputString = RTRIM(LTRIM(@.InputString ))
WHILE (CHARINDEX(@.Delimiter, @.InputString)) > 0
BEGIN
SET @.Temp = RTRIM(LTRIM(LEFT(@.InputString, CHARINDEX(@.Delimiter,
@.InputString)-1)))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
SET @.InputString = RIGHT(@.InputString, LEN(@.InputString) -
CHARINDEX(@.Delimiter,@.InputString))
END
SET @.Temp = RTRIM(LTRIM(@.InputString))
IF @.Temp != ''
INSERT @.IntList Values(@.Temp)
RETURN
END
GO
----
"Jocelyn" <j_chaumette@.yahoo.fr> wrote in message
news:15fe105b.0407202353.225402c4@.posting.google.com...
> Thanks a lot!
> It did work :) .
> But actually, it was only the first step of my tests and I have now a
> new issue.
> As I have explained earlier (I think I did...), I need a multi-value
> field parameter. This is the only reason why I'm making this html
> page.
> For the moment, the single value field works but I can't make it with
> a multi-value field. It seems that my query is simply not good.
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (@.EmpId))
> I also tried to test the syntax of the list in the parameter, using
> this query:
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN (20,21))
> and then I tried
> SELECT FirstName, MiddleName, LastName, AddressID
> FROM Employee
> WHERE (EmployeeID IN ('20','21'))
> The report appears empty (the value 20 and 21 are good and the report
> parameter is an integer).
> Any Idea of how I should do?

i can not access to database

Login failed for user 'FAMILY\ASPNET'.

this is the error message when i connect to database, FAMILY is my computer name.

my connection string is: "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=forum"

You will need to configure access on your database for the ASPNET account that is used to run your ASP.NET applications.

To do this, launch SQL Server Management Studio (or Management Studio Express), expand the Security item until you see the Logins node, right click on it and choose New Login...

In the resulting dialog, select the ASPNET account. You will then need to configure the database to allow access for that user (expand the database tree to find the db, check out the Security > Users and Security > Roles for more information).

Note that it is tempting to simply add the ASPNET account to the Administrators group on the machine, as Administrators tends to get full access to the db. Avoid doing this: it's not a great security option.

|||i've got it. thanks a lot

I am unable to access Analysis Server with AMO

Hi All,

I developed one web service,Here i am making connection to the Analysis Server and working on Database,cubes,partitions.when i deploy this code it is failing to run and it is throwing error like."object reference not set to an instance of the object",so i added Impersonate = true code in my web service config file then it is working fine.

( am expecting My Analysis Server is not allowing to create object ,how to handle this)

But what i want is it should work with out providing Impersonate in config.

Help is needed it is very urgent.

Thanks in Advance.

You code has to run under the priviledges of some sort of account. There are only 3 possible configurations that I can think of.

1. Setup an account in the application pool (if using IIS6)

2. Set a fixed account using the <identity impersonate="true" userName="..." password="..." /> tag in the web.config

3. Set the current client account to be impersonated using <identity impersonate="true" /> in the web.config

Note that 3) will only work if the web service and SSAS are on the same machine, or if you have Kerberos configured. Otherwise the user credentials will not pass from client to Web server to SSAS server.

i am trying to move from Access db to Sql.s

hello

i am trying to move from Access db to Sql.s

could you please what is rwong in the sql.s syntax:

Access SP:-

PARAMETERS [@.Date_M_Y] DateTime, [@.BIZID] Long;
SELECT SUM(MINUTE(Time_)) AS MM, SUM(HOUR(Time_)) AS HH, COUNT(Date_) AS SHIFTS, SUM(Money_Sum) AS MONEY_TOTAL, AVG(Money_Sum) AS AVG_MONEY_PER_SHIFT
FROM TblTimeSum
WHERE MONTH(Date_)=MONTH([@.Date_M_Y]) And YEAR(Date_)=YEAR([@.Date_M_Y]) And BIZID=[@.BIZID];

-- SQL.S-

CREATE PROCEDURE SP_SUM

@.Date_M_Y smalldatetime,

@.BIZID int

AS

BEGIN

SELECT SUM(MINUTE(Time_)) AS MM, SUM(HOUR(Time_)) AS HH, COUNT(Date_) AS SHIFTS, SUM(Money_Sum) AS MONEY_TOTAL, AVG(Money_Sum) AS AVG_MONEY_PER_SHIFT

FROM TblTimeSum

WHERE MONTH(Date_)=MONTH([@.Date_M_Y]) And YEAR(Date_)=YEAR([@.Date_M_Y]) And BIZID=[@.BIZID]

END

GO

thanks

I don't believe that T-SQL has a Minute function. Try using the DATEPART function in place of the MINUTE function.

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

|||

I think that this has been answered in the Transact-SQL forum.

Often, the quality of the responses received is related to our ability to ‘bounce’ ideas off of each other. In the future, to make it easier for us to offer you assistance, and to prevent folks from wasting time on already answered questions, please don't post to multiple newsgroups. Choose the one that best fits your question and post there. Only post to another newsgroup if you get no answer in a day or two (or if you accidentally posted to the wrong newsgroup –and you indicate that you've already posted elsewhere).

|||

Arnie Rowland wrote:

I think that this has been answered in the Transact-SQL forum.

Often, the quality of the responses received is related to our ability to ‘bounce’ ideas off of each other. In the future, to make it easier for us to offer you assistance, and to prevent folks from wasting time on already answered questions, please don't post to multiple newsgroups. Choose the one that best fits your question and post there. Only post to another newsgroup if you get no answer in a day or two (or if you accidentally posted to the wrong newsgroup –and you indicate that you've already posted elsewhere).

Yes this is very tasteful, welcoming, and polite. It directly answers the original question and promotes deep thought. A good example of the quality found within. If each of us posted this rude comment, the world would be a better place to live but I guess that's how MVP status is obtained.

Let's pass the love forward.

Very nice Arnie. Keep it up.

|||

Yes the date and time functions need to be acheived through a CONVERT() format.

Adamus

I am trying to convert a MS Access Query to a SQL query and I need help?

I am trying to convert a MS Access Query to a SQL query and I need help with some IIF Statements?

2 in particular that I've encountered problems with are:

Count(IIf([elphoursflag]=0 Or [elphoursflag]=2,IIf([envelopes].isitecode=[logsheets].isitecode,IIf([recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd([d],13,[dFirstPSYDate])),[zip]))))'AS wk2count,

AND

Format(Avg(IIf([elphoursflag]=0 Or [elphoursflag]=2,IIf([envelopes].isitecode=[logsheets].isitecode,IIf([recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd([d],13,[dFirstPSYDate])),[elphours])))),[0.0])AS wk2avg,

Any help that someone could offer would be greatly appreciated!
Thanks!After some more effort, I was able to get this working:
Count(case
when [elphoursflag]=0 Or [elphoursflag]=2 then
case
when [envelopes].isitecode=[logsheets].isitecode then
case
when [recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd([d],13,[dFirstPSYDate])) then
[zip]
end
end
end) AS wk2count,
Round(Avg(case
when [elphoursflag]=0 Or [elphoursflag]=2 then
case
when [envelopes].isitecode=[logsheets].isitecode then
case
when [recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd(day,13,[dFirstPSYDate])) then
elphours
end
end
end), 0.0) AS wk2avg,

Quote:

Originally Posted by newtechiebug

I am trying to convert a MS Access Query to a SQL query and I need help with some IIF Statements?

2 in particular that I've encountered problems with are:

Count(IIf([elphoursflag]=0 Or [elphoursflag]=2,IIf([envelopes].isitecode=[logsheets].isitecode,IIf([recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd([d],13,[dFirstPSYDate])),[zip]))))'AS wk2count,

AND

Format(Avg(IIf([elphoursflag]=0 Or [elphoursflag]=2,IIf([envelopes].isitecode=[logsheets].isitecode,IIf([recdate] Between DateAdd([d],7,[dFirstPSYDate]) And (DateAdd([d],13,[dFirstPSYDate])),[elphours])))),[0.0])AS wk2avg,

Any help that someone could offer would be greatly appreciated!
Thanks!

I am new for SQL Server please help me to write the code

Hi Dear all

I am new for SQL Server I know VB Programming and Access also but I don't know about SQL Server pls help me or guide me the web site.

Thank U in advance.http://www.w3schools.com/sql/default.asp