I have a standard reorganise/reindex job running against a 32GB database on SQl Srever 2000. When trying to run the job it fails and returns Error 1105 <'PRIMARY' filegroup is full>. What's confusing me is that I have 53GB free on the drive on which my Primary file group sits.
Has anyone else come accross this problem when trying to set up a regular reindex job?
(more detail) the maintenance plan only includes the reorganisation/reindex job, no other jobs - including backing up the DB - are included. The DB in question is the only DB on the server: it's a test server.Sounds like you've restricted the file growth size...go to the database properties and tell us what it's set to...|||Brett,
You were right, log size was being restricted. Funny how you miss the obvious stuff.....
Many Thanks
Matthew
Showing posts with label standard. Show all posts
Showing posts with label standard. Show all posts
Sunday, March 11, 2012
Friday, March 9, 2012
Error 0x800ccc6a
Hi,
we are using an SMTP Server, which just works fine with other applications.
But if we try to send reports by e-mail, using the standard e-mail
subscription of report manager, we get this message:
"Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x800ccc6a. The server response was 451 4.7.1 Please
try again later".
Verifying the ReportServerService log, I found this message:
"Error sending email. System.Runtime.InteropServices.COMException
(0x80040211): The message could not be sent to the SMTP server. The transport
error code was 0x800ccc6a. The server response was 451 4.7.1 Please try again
later".
The smtp configuration in the RSReportServer config file is:
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>111.11.11.111</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName>anyone@.company.com</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>anyone@.company.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
Can anyone help me?
Thanks
pwiThe error you're describing is a generic SMTP server error:
0x800CCC6A SMTP_451_ERROR_PROCESSING Error processing request.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;208814)
Hmm... what does your SMTP server's log say?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pwi" <pwi@.discussions.microsoft.com> wrote in message
news:70B81ABA-AA13-4E1C-BD44-55CF66CF86F3@.microsoft.com...
> Hi,
> we are using an SMTP Server, which just works fine with other
> applications.
> But if we try to send reports by e-mail, using the standard e-mail
> subscription of report manager, we get this message:
> "Failure sending mail: The message could not be sent to the SMTP server.
> The
> transport error code was 0x800ccc6a. The server response was 451 4.7.1
> Please
> try again later".
> Verifying the ReportServerService log, I found this message:
> "Error sending email. System.Runtime.InteropServices.COMException
> (0x80040211): The message could not be sent to the SMTP server. The
> transport
> error code was 0x800ccc6a. The server response was 451 4.7.1 Please try
> again
> later".
> The smtp configuration in the RSReportServer config file is:
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>111.11.11.111</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName>anyone@.company.com</SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>anyone@.company.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> Can anyone help me?
> Thanks
> pwi
>
we are using an SMTP Server, which just works fine with other applications.
But if we try to send reports by e-mail, using the standard e-mail
subscription of report manager, we get this message:
"Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x800ccc6a. The server response was 451 4.7.1 Please
try again later".
Verifying the ReportServerService log, I found this message:
"Error sending email. System.Runtime.InteropServices.COMException
(0x80040211): The message could not be sent to the SMTP server. The transport
error code was 0x800ccc6a. The server response was 451 4.7.1 Please try again
later".
The smtp configuration in the RSReportServer config file is:
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>111.11.11.111</SMTPServer>
<SMTPServerPort>25</SMTPServerPort>
<SMTPAccountName>anyone@.company.com</SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>2</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>anyone@.company.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
Can anyone help me?
Thanks
pwiThe error you're describing is a generic SMTP server error:
0x800CCC6A SMTP_451_ERROR_PROCESSING Error processing request.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;208814)
Hmm... what does your SMTP server's log say?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pwi" <pwi@.discussions.microsoft.com> wrote in message
news:70B81ABA-AA13-4E1C-BD44-55CF66CF86F3@.microsoft.com...
> Hi,
> we are using an SMTP Server, which just works fine with other
> applications.
> But if we try to send reports by e-mail, using the standard e-mail
> subscription of report manager, we get this message:
> "Failure sending mail: The message could not be sent to the SMTP server.
> The
> transport error code was 0x800ccc6a. The server response was 451 4.7.1
> Please
> try again later".
> Verifying the ReportServerService log, I found this message:
> "Error sending email. System.Runtime.InteropServices.COMException
> (0x80040211): The message could not be sent to the SMTP server. The
> transport
> error code was 0x800ccc6a. The server response was 451 4.7.1 Please try
> again
> later".
> The smtp configuration in the RSReportServer config file is:
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>111.11.11.111</SMTPServer>
> <SMTPServerPort>25</SMTPServerPort>
> <SMTPAccountName>anyone@.company.com</SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing>2</SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From>anyone@.company.com</From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> Can anyone help me?
> Thanks
> pwi
>
Friday, February 24, 2012
Error "Connection is busy with results for another command"
I have looked at other threads regarding errors similar to this, but I think mine is a bit different.
I am using SQL2005 Standard Edition and my application is coded with C# using ADO.Net. OLEDB connection is used. The error occurs when the application has only one thread accessing the database. It does not happen consistently, so it is very puzzling.
I am wondering if anyone could offer any tip to diagnose this.
Thanks in advance!
Have a look at this article: http://blogs.msdn.com/dataaccess/archive/2005/08/02/446894.aspxError "Cannot resolve the collation conflict between"
I'm getting the following errors when trying to execute the following script on the server, its part of the standard asp.net membership and roles, anybody have any ideas how I get get round this?
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 50
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 84
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] Script Date: 05/20/2007 11:23:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @.statement = N'
CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]
@.ApplicationName nvarchar(256),
@.UserNames nvarchar(4000),
@.RoleNames nvarchar(4000)
AS
BEGIN
DECLARE @.AppId uniqueidentifier
SELECT @.AppId = NULL
SELECT @.AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@.ApplicationName) = LoweredApplicationName
IF (@.AppId IS NULL)
RETURN(2)
DECLARE @.TranStarted bit
SET @.TranStarted = 0
IF( @.@.TRANCOUNT = 0 )
BEGIN
BEGIN TRANSACTION
SET @.TranStarted = 1
END
DECLARE @.tbNames table(Name nvarchar(256) NOT NULL PRIMARY KEY)
DECLARE @.tbRoles table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)
DECLARE @.tbUsers table(UserId uniqueidentifier NOT NULL PRIMARY KEY)
DECLARE @.Num int
DECLARE @.Pos int
DECLARE @.NextPos int
DECLARE @.Name nvarchar(256)
DECLARE @.CountAll int
DECLARE @.CountU int
DECLARE @.CountR int
SET @.Num = 0
SET @.Pos = 1
WHILE(@.Pos <= LEN(@.RoleNames))
BEGIN
SELECT @.NextPos = CHARINDEX(N'','', @.RoleNames, @.Pos)
IF (@.NextPos = 0 OR @.NextPos IS NULL)
SELECT @.NextPos = LEN(@.RoleNames) + 1
SELECT @.Name = RTRIM(LTRIM(SUBSTRING(@.RoleNames, @.Pos, @.NextPos - @.Pos)))
SELECT @.Pos = @.NextPos+1
INSERT INTO @.tbNames VALUES (@.Name)
SET @.Num = @.Num + 1
END
INSERT INTO @.tbRoles
SELECT RoleId
FROM dbo.aspnet_Roles ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @.AppId
SELECT @.CountR = @.@.ROWCOUNT
IF (@.CountR <> @.Num)
BEGIN
SELECT TOP 1 N'''', Name
FROM @.tbNames
WHERE LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar, @.tbRoles r WHERE r.RoleId = ar.RoleId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(2)
END
DELETE FROM @.tbNames WHERE 1=1
SET @.Num = 0
SET @.Pos = 1
WHILE(@.Pos <= LEN(@.UserNames))
BEGIN
SELECT @.NextPos = CHARINDEX(N'','', @.UserNames, @.Pos)
IF (@.NextPos = 0 OR @.NextPos IS NULL)
SELECT @.NextPos = LEN(@.UserNames) + 1
SELECT @.Name = RTRIM(LTRIM(SUBSTRING(@.UserNames, @.Pos, @.NextPos - @.Pos)))
SELECT @.Pos = @.NextPos+1
INSERT INTO @.tbNames VALUES (@.Name)
SET @.Num = @.Num + 1
END
INSERT INTO @.tbUsers
SELECT UserId
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId
SELECT @.CountU = @.@.ROWCOUNT
IF (@.CountU <> @.Num)
BEGIN
SELECT TOP 1 Name, N''''
FROM @.tbNames
WHERE LOWER(Name) NOT IN (SELECT au.LoweredUserName FROM dbo.aspnet_Users au, @.tbUsers u WHERE u.UserId = au.UserId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(1)
END
SELECT @.CountAll = COUNT(*)
FROM dbo.aspnet_UsersInRoles ur, @.tbUsers u, @.tbRoles r
WHERE ur.UserId = u.UserId AND ur.RoleId = r.RoleId
IF (@.CountAll <> @.CountU * @.CountR)
BEGIN
SELECT TOP 1 UserName, RoleName
FROM @.tbUsers tu, @.tbRoles tr, dbo.aspnet_Users u, dbo.aspnet_Roles r
WHERE u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND
tu.UserId NOT IN (SELECT ur.UserId FROM dbo.aspnet_UsersInRoles ur WHERE ur.RoleId = tr.RoleId) AND
tr.RoleId NOT IN (SELECT ur.RoleId FROM dbo.aspnet_UsersInRoles ur WHERE ur.UserId = tu.UserId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(3)
END
DELETE FROM dbo.aspnet_UsersInRoles
WHERE UserId IN (SELECT UserId FROM @.tbUsers)
AND RoleId IN (SELECT RoleId FROM @.tbRoles)
IF( @.TranStarted = 1 )
COMMIT TRANSACTION
RETURN(0)
END
'
END
GO
ThanksThis is because the collations are not consistent across the database tables and the tables that have been created.
Try adding the COLLATE to your insert queries.
something like
INSERT INTO @.tbUsers
SELECT UserId COLLATE SQL_Latin1_General_CP1_CI_AS
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId
or
INSERT INTO @.tbUsers
SELECT UserId COLLATE Latin1_General_CI_AS
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId
coz i really dont know which one is conflicting.....i mean which collation|||Yes your right the db and the table fields have different collation values but I don't understand how to change this as this was installed by .net, Can I change this and will it have any impact, Its funny because I've scripted the db from my dev machine and its working fine and now that I'm trying to create it on my host .. Wierd
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 50
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 58
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 84
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
Msg 468, Level 16, State 9, Procedure aspnet_UsersInRoles_RemoveUsersFromRoles, Line 92
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
/****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] Script Date: 05/20/2007 11:23:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @.statement = N'
CREATE PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]
@.ApplicationName nvarchar(256),
@.UserNames nvarchar(4000),
@.RoleNames nvarchar(4000)
AS
BEGIN
DECLARE @.AppId uniqueidentifier
SELECT @.AppId = NULL
SELECT @.AppId = ApplicationId FROM aspnet_Applications WHERE LOWER(@.ApplicationName) = LoweredApplicationName
IF (@.AppId IS NULL)
RETURN(2)
DECLARE @.TranStarted bit
SET @.TranStarted = 0
IF( @.@.TRANCOUNT = 0 )
BEGIN
BEGIN TRANSACTION
SET @.TranStarted = 1
END
DECLARE @.tbNames table(Name nvarchar(256) NOT NULL PRIMARY KEY)
DECLARE @.tbRoles table(RoleId uniqueidentifier NOT NULL PRIMARY KEY)
DECLARE @.tbUsers table(UserId uniqueidentifier NOT NULL PRIMARY KEY)
DECLARE @.Num int
DECLARE @.Pos int
DECLARE @.NextPos int
DECLARE @.Name nvarchar(256)
DECLARE @.CountAll int
DECLARE @.CountU int
DECLARE @.CountR int
SET @.Num = 0
SET @.Pos = 1
WHILE(@.Pos <= LEN(@.RoleNames))
BEGIN
SELECT @.NextPos = CHARINDEX(N'','', @.RoleNames, @.Pos)
IF (@.NextPos = 0 OR @.NextPos IS NULL)
SELECT @.NextPos = LEN(@.RoleNames) + 1
SELECT @.Name = RTRIM(LTRIM(SUBSTRING(@.RoleNames, @.Pos, @.NextPos - @.Pos)))
SELECT @.Pos = @.NextPos+1
INSERT INTO @.tbNames VALUES (@.Name)
SET @.Num = @.Num + 1
END
INSERT INTO @.tbRoles
SELECT RoleId
FROM dbo.aspnet_Roles ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredRoleName AND ar.ApplicationId = @.AppId
SELECT @.CountR = @.@.ROWCOUNT
IF (@.CountR <> @.Num)
BEGIN
SELECT TOP 1 N'''', Name
FROM @.tbNames
WHERE LOWER(Name) NOT IN (SELECT ar.LoweredRoleName FROM dbo.aspnet_Roles ar, @.tbRoles r WHERE r.RoleId = ar.RoleId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(2)
END
DELETE FROM @.tbNames WHERE 1=1
SET @.Num = 0
SET @.Pos = 1
WHILE(@.Pos <= LEN(@.UserNames))
BEGIN
SELECT @.NextPos = CHARINDEX(N'','', @.UserNames, @.Pos)
IF (@.NextPos = 0 OR @.NextPos IS NULL)
SELECT @.NextPos = LEN(@.UserNames) + 1
SELECT @.Name = RTRIM(LTRIM(SUBSTRING(@.UserNames, @.Pos, @.NextPos - @.Pos)))
SELECT @.Pos = @.NextPos+1
INSERT INTO @.tbNames VALUES (@.Name)
SET @.Num = @.Num + 1
END
INSERT INTO @.tbUsers
SELECT UserId
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId
SELECT @.CountU = @.@.ROWCOUNT
IF (@.CountU <> @.Num)
BEGIN
SELECT TOP 1 Name, N''''
FROM @.tbNames
WHERE LOWER(Name) NOT IN (SELECT au.LoweredUserName FROM dbo.aspnet_Users au, @.tbUsers u WHERE u.UserId = au.UserId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(1)
END
SELECT @.CountAll = COUNT(*)
FROM dbo.aspnet_UsersInRoles ur, @.tbUsers u, @.tbRoles r
WHERE ur.UserId = u.UserId AND ur.RoleId = r.RoleId
IF (@.CountAll <> @.CountU * @.CountR)
BEGIN
SELECT TOP 1 UserName, RoleName
FROM @.tbUsers tu, @.tbRoles tr, dbo.aspnet_Users u, dbo.aspnet_Roles r
WHERE u.UserId = tu.UserId AND r.RoleId = tr.RoleId AND
tu.UserId NOT IN (SELECT ur.UserId FROM dbo.aspnet_UsersInRoles ur WHERE ur.RoleId = tr.RoleId) AND
tr.RoleId NOT IN (SELECT ur.RoleId FROM dbo.aspnet_UsersInRoles ur WHERE ur.UserId = tu.UserId)
IF( @.TranStarted = 1 )
ROLLBACK TRANSACTION
RETURN(3)
END
DELETE FROM dbo.aspnet_UsersInRoles
WHERE UserId IN (SELECT UserId FROM @.tbUsers)
AND RoleId IN (SELECT RoleId FROM @.tbRoles)
IF( @.TranStarted = 1 )
COMMIT TRANSACTION
RETURN(0)
END
'
END
GO
ThanksThis is because the collations are not consistent across the database tables and the tables that have been created.
Try adding the COLLATE to your insert queries.
something like
INSERT INTO @.tbUsers
SELECT UserId COLLATE SQL_Latin1_General_CP1_CI_AS
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId
or
INSERT INTO @.tbUsers
SELECT UserId COLLATE Latin1_General_CI_AS
FROM dbo.aspnet_Users ar, @.tbNames t
WHERE LOWER(t.Name) = ar.LoweredUserName AND ar.ApplicationId = @.AppId
coz i really dont know which one is conflicting.....i mean which collation|||Yes your right the db and the table fields have different collation values but I don't understand how to change this as this was installed by .net, Can I change this and will it have any impact, Its funny because I've scripted the db from my dev machine and its working fine and now that I'm trying to create it on my host .. Wierd
Wednesday, February 15, 2012
Erro install Reportig Service
> Hello,
>
> I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> Standard, but appers error message no log file rsstp.log
>
> InstallBootstrapPackage' Return='2' GetLastError='183
>
> anyone can help me?
> Clayton Cardozo.hi i am having trouble opening my emails it just goes in to error
"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
>
>|||"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
> i need help opening my email it has been ok upto now not sure whats happened it just goes in to error everytime i try.
>
>
> I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> Standard, but appers error message no log file rsstp.log
>
> InstallBootstrapPackage' Return='2' GetLastError='183
>
> anyone can help me?
> Clayton Cardozo.hi i am having trouble opening my emails it just goes in to error
"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
>
>|||"Clayton Cardozo" wrote:
> > Hello,
> >
> > I`m try install Microsoft SQL Reporting Service 2000 in Windows 2003
> > Standard, but appers error message no log file rsstp.log
> >
> > InstallBootstrapPackage' Return='2' GetLastError='183
> >
> > anyone can help me?
> > Clayton Cardozo.
> i need help opening my email it has been ok upto now not sure whats happened it just goes in to error everytime i try.
>
ERREUR to open a data base with SSMSEE
I installed Visual Studio 2005 Standard Edition which contains SQL Server Express.
I downloaded and installed SQL Server Management Studio Express. It run !
I established a connection server BellFixe\SQLEXPRESS (BellFixe is the name of my computer). Ok.
The command " add " of the function " attach " of SSMSE allows to navigate on the disk and to attach diverse data bases but it refuses to open the directory D:\Documents and Settings\Alain (this path is the base of all my directories of data). This directory appears empty. I cannot thus attach the data bases which are under this directory !
I can open a data base only if it is elsewhere localised.
Why this limitation of access and how to resolve this problem? There is certainly a relation with the management of the users of the PC.
I am only user and administrator of my PC under XP. All my directories of data are under D:\Documents and Settings\Alain. The explorer Windows allows to navigate everywhere the disk.
Tanks.
hi,
the position you specfied is not a good one for such a kind of data as it is meant as "private" storage for the current (aka Alain) logged user... you should modify the path to something available to all users, even if SQLExpress always is run under the credential of the account you specified at install time or later, via the Surface Area Configuration or SQL Server Configuration Manager..
regards
|||But SSMSEE should be able to cross all the disk, in mode administrator. He is not right for such a limitaion there is not it ?
This is only an MSDN exercise "Coatch ASP.NET". But it is blocking for me.
Regards
|||hi,
AchLog wrote:
But SSMSEE should be able to cross all the disk, in mode administrator. He is not right for such a limitaion there is not it ?
is your SQL Server engine service running under Network Service or Local Service account?
please verify via SQL Server Configuration Manager..
regards
|||Thank You for your answer Andrea.
SQL Server is local on my machine of development.
I have not yet understood how to verify the connexion mode with SQL Server Configuration Manager. I am a little bit novice with SQL Server and his tools.
Can you tell me how to verify it?
Here method indicated by coach ASP.NET to attach a local data base with SSMSEE. On my computer it is the step 4 which does not function.
===========================================
A simple solution is to attach your data base to your waiter SQL Express. It is now very easy with the console of administration “SQL Server Management Studio Express train” of the final version of SQL Server Express:
1 - to launch the console of administration since the menu To start/All the programs/Microsoft SQL Server 2005/SQL Server Management Studio Express train CTP.
2 - connect to the waiter of name”. \ SQLExpress " via the Windows authentification.
3 - in the explorer of object, made a right click on the file “Databases” then the order “attach”.
4 - find on the disc your file .mdf and add it. Your data base is now attached to SQL Server. You must see it in the list of the data bases of the console.
============================================
Thank you
|||
Thank You for your answer Andrea.
SQL Server is local on my machine of development.
I have not yet understood how to verify the connexion mode with SQL Server Configuration Manager. I am a little bit novice with SQL Server and his tools.
Can you tell me how to verify it?
execute the SQL Server Configuration Manager.. in the SQL Server services locate the SQL Server engine you are dealing with.. right click on it and access it's properties.. you can there see (and set) the account running the services... if you modify it you have to restart the service..
Here method indicated by coach ASP.NET to attach a local data base with SSMSEE. On my computer it is the step 4 which does not function.
===========================================
A simple solution is to attach your data base to your waiter SQL Express. It is now very easy with the console of administration “SQL Server Management Studio Express train” of the final version of SQL Server Express:
1 - to launch the console of administration since the menu To start/All the programs/Microsoft SQL Server 2005/SQL Server Management Studio Express train CTP.
2 - connect to the waiter of name”. \ SQLExpress " via the Windows authentification.
3 - in the explorer of object, made a right click on the file “Databases” then the order “attach”.
4 - find on the disc your file .mdf and add it. Your data base is now attached to SQL Server. You must see it in the list of the data bases of the console.
============================================
Thank you
the "explanation" is correct... this is the "traditional" way to attach a database to a SQL Server instance via SSMS (and SSMSE), but not to "user instances" as the perform differently...
regards
|||Tank You Andrea,
The parameters are the following ones :
Name : bellfixe\sqlexpress
ERREUR to open a data base with SSMSEE
I installed Visual Studio 2005 Standard Edition which contains SQL Server Express.
I downloaded and installed SQL Server Management Studio Express. It run !
I established a connection server BellFixe\SQLEXPRESS (BellFixe is the name of my computer). Ok.
The command " add " of the function " attach " of SSMSE allows to navigate on the disk and to attach diverse data bases but it refuses to open the directory D:\Documents and Settings\Alain (this path is the base of all my directories of data). This directory appears empty. I cannot thus attach the data bases which are under this directory !
I can open a data base only if it is elsewhere localised.
Why this limitation of access and how to resolve this problem? There is certainly a relation with the management of the users of the PC.
I am only user and administrator of my PC under XP. All my directories of data are under D:\Documents and Settings\Alain. The explorer Windows allows to navigate everywhere the disk.
Tanks.
hi,
the position you specfied is not a good one for such a kind of data as it is meant as "private" storage for the current (aka Alain) logged user... you should modify the path to something available to all users, even if SQLExpress always is run under the credential of the account you specified at install time or later, via the Surface Area Configuration or SQL Server Configuration Manager..
regards
|||But SSMSEE should be able to cross all the disk, in mode administrator. He is not right for such a limitaion there is not it ?
This is only an MSDN exercise "Coatch ASP.NET". But it is blocking for me.
Regards
|||hi,
AchLog wrote:
But SSMSEE should be able to cross all the disk, in mode administrator. He is not right for such a limitaion there is not it ?
is your SQL Server engine service running under Network Service or Local Service account?
please verify via SQL Server Configuration Manager..
regards
|||Thank You for your answer Andrea.
SQL Server is local on my machine of development.
I have not yet understood how to verify the connexion mode with SQL Server Configuration Manager. I am a little bit novice with SQL Server and his tools.
Can you tell me how to verify it?
Here method indicated by coach ASP.NET to attach a local data base with SSMSEE. On my computer it is the step 4 which does not function.
===========================================
A simple solution is to attach your data base to your waiter SQL Express. It is now very easy with the console of administration “SQL Server Management Studio Express train” of the final version of SQL Server Express:
1 - to launch the console of administration since the menu To start/All the programs/Microsoft SQL Server 2005/SQL Server Management Studio Express train CTP.
2 - connect to the waiter of name”. \ SQLExpress " via the Windows authentification.
3 - in the explorer of object, made a right click on the file “Databases” then the order “attach”.
4 - find on the disc your file .mdf and add it. Your data base is now attached to SQL Server. You must see it in the list of the data bases of the console.
============================================
Thank you
|||
Thank You for your answer Andrea.
SQL Server is local on my machine of development.
I have not yet understood how to verify the connexion mode with SQL Server Configuration Manager. I am a little bit novice with SQL Server and his tools.
Can you tell me how to verify it?
execute the SQL Server Configuration Manager.. in the SQL Server services locate the SQL Server engine you are dealing with.. right click on it and access it's properties.. you can there see (and set) the account running the services... if you modify it you have to restart the service..
Here method indicated by coach ASP.NET to attach a local data base with SSMSEE. On my computer it is the step 4 which does not function.
===========================================
A simple solution is to attach your data base to your waiter SQL Express. It is now very easy with the console of administration “SQL Server Management Studio Express train” of the final version of SQL Server Express:
1 - to launch the console of administration since the menu To start/All the programs/Microsoft SQL Server 2005/SQL Server Management Studio Express train CTP.
2 - connect to the waiter of name”. \ SQLExpress " via the Windows authentification.
3 - in the explorer of object, made a right click on the file “Databases” then the order “attach”.
4 - find on the disc your file .mdf and add it. Your data base is now attached to SQL Server. You must see it in the list of the data bases of the console.
============================================
Thank you
the "explanation" is correct... this is the "traditional" way to attach a database to a SQL Server instance via SSMS (and SSMSE), but not to "user instances" as the perform differently...
regards
|||Tank You Andrea,
The parameters are the following ones :
Name : bellfixe\sqlexpress
Subscribe to:
Posts (Atom)