Hi,
I am new to MS-SQL and I have a problem. Actually I have made similar
queries on Oracle, but now I failed on MS Sql. First of all I am using
SQL Server 2005, but I think it is not that much important because my
question is related something fundamental.
I want to compare the result (which should be random) in one table,
with another one in another table and if they are same, I want to check
the other information. In both tables the column name is the same.
So far I have tried:
1.
SELECT TOP 1 pictureID FROM Pictures INNER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID()
and got the error: Ambiguous column name 'pictureID'.
2.
SELECT TOP 1 Pictures.pictureID FROM Pictures INNER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID()
and got the error: There is no row at position 0.
3.
SELECT TOP 1 Pictures.pictureID FROM Pictures LEFT OUTER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID
This query hasn't returned an error, but doesnt return the desired
result.
4.
SELECT TOP 1 Pictures.pictureID FROM Pictures, Views WHERE
Pictures.pictureID = Views.pictureID AND Pictures.active='Y' ORDER BY
NEWID()
This query also hasn't returned an error, but doesnt return the desired
result too.
Thanks in advance for your help.I don't understand your request. (Your queries below will only compare
PictureID.)
Are you wanting to know if rows exists in one table and ALSO in another
table?
Or do they exists in one table but NOT in the other table.
If so, must all fields match?
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dot Net Daddy" <cagriandac@.gmail.com> wrote in message
news:1154637672.972725.282200@.p79g2000cwp.googlegroups.com...
> Hi,
> I am new to MS-SQL and I have a problem. Actually I have made similar
> queries on Oracle, but now I failed on MS Sql. First of all I am using
> SQL Server 2005, but I think it is not that much important because my
> question is related something fundamental.
> I want to compare the result (which should be random) in one table,
> with another one in another table and if they are same, I want to check
> the other information. In both tables the column name is the same.
> So far I have tried:
>
> 1.
> SELECT TOP 1 pictureID FROM Pictures INNER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID()
> and got the error: Ambiguous column name 'pictureID'.
>
> 2.
> SELECT TOP 1 Pictures.pictureID FROM Pictures INNER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID()
> and got the error: There is no row at position 0.
>
> 3.
> SELECT TOP 1 Pictures.pictureID FROM Pictures LEFT OUTER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID
> This query hasn't returned an error, but doesnt return the desired
> result.
>
> 4.
> SELECT TOP 1 Pictures.pictureID FROM Pictures, Views WHERE
> Pictures.pictureID = Views.pictureID AND Pictures.active='Y' ORDER BY
> NEWID()
> This query also hasn't returned an error, but doesnt return the desired
> result too.
>
> Thanks in advance for your help.
>sql
Showing posts with label failed. Show all posts
Showing posts with label failed. Show all posts
Wednesday, March 28, 2012
Help On SQL Query
Hi,
I am new to MS-SQL and I have a problem. Actually I have made similar
queries on Oracle, but now I failed on MS Sql. First of all I am using
SQL Server 2005, but I think it is not that much important because my
question is related something fundamental.
I want to compare the result (which should be random) in one table,
with another one in another table and if they are same, I want to check
the other information. In both tables the column name is the same.
So far I have tried:
1.
SELECT TOP 1 pictureID FROM Pictures INNER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID()
and got the error: Ambiguous column name 'pictureID'.
2.
SELECT TOP 1 Pictures.pictureID FROM Pictures INNER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID()
and got the error: There is no row at position 0.
3.
SELECT TOP 1 Pictures.pictureID FROM Pictures LEFT OUTER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID
This query hasn't returned an error, but doesnt return the desired
result.
4.
SELECT TOP 1 Pictures.pictureID FROM Pictures, Views WHERE
Pictures.pictureID = Views.pictureID AND Pictures.active='Y' ORDER BY
NEWID()
This query also hasn't returned an error, but doesnt return the desired
result too.
Thanks in advance for your help.I don't understand your request. (Your queries below will only compare
PictureID.)
Are you wanting to know if rows exists in one table and ALSO in another
table?
Or do they exists in one table but NOT in the other table.
If so, must all fields match?
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dot Net Daddy" <cagriandac@.gmail.com> wrote in message
news:1154637672.972725.282200@.p79g2000cwp.googlegroups.com...
> Hi,
> I am new to MS-SQL and I have a problem. Actually I have made similar
> queries on Oracle, but now I failed on MS Sql. First of all I am using
> SQL Server 2005, but I think it is not that much important because my
> question is related something fundamental.
> I want to compare the result (which should be random) in one table,
> with another one in another table and if they are same, I want to check
> the other information. In both tables the column name is the same.
> So far I have tried:
>
> 1.
> SELECT TOP 1 pictureID FROM Pictures INNER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID()
> and got the error: Ambiguous column name 'pictureID'.
>
> 2.
> SELECT TOP 1 Pictures.pictureID FROM Pictures INNER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID()
> and got the error: There is no row at position 0.
>
> 3.
> SELECT TOP 1 Pictures.pictureID FROM Pictures LEFT OUTER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID
> This query hasn't returned an error, but doesnt return the desired
> result.
>
> 4.
> SELECT TOP 1 Pictures.pictureID FROM Pictures, Views WHERE
> Pictures.pictureID = Views.pictureID AND Pictures.active='Y' ORDER BY
> NEWID()
> This query also hasn't returned an error, but doesnt return the desired
> result too.
>
> Thanks in advance for your help.
>
I am new to MS-SQL and I have a problem. Actually I have made similar
queries on Oracle, but now I failed on MS Sql. First of all I am using
SQL Server 2005, but I think it is not that much important because my
question is related something fundamental.
I want to compare the result (which should be random) in one table,
with another one in another table and if they are same, I want to check
the other information. In both tables the column name is the same.
So far I have tried:
1.
SELECT TOP 1 pictureID FROM Pictures INNER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID()
and got the error: Ambiguous column name 'pictureID'.
2.
SELECT TOP 1 Pictures.pictureID FROM Pictures INNER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID()
and got the error: There is no row at position 0.
3.
SELECT TOP 1 Pictures.pictureID FROM Pictures LEFT OUTER JOIN Views ON
Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
NEWID
This query hasn't returned an error, but doesnt return the desired
result.
4.
SELECT TOP 1 Pictures.pictureID FROM Pictures, Views WHERE
Pictures.pictureID = Views.pictureID AND Pictures.active='Y' ORDER BY
NEWID()
This query also hasn't returned an error, but doesnt return the desired
result too.
Thanks in advance for your help.I don't understand your request. (Your queries below will only compare
PictureID.)
Are you wanting to know if rows exists in one table and ALSO in another
table?
Or do they exists in one table but NOT in the other table.
If so, must all fields match?
It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 )
The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dot Net Daddy" <cagriandac@.gmail.com> wrote in message
news:1154637672.972725.282200@.p79g2000cwp.googlegroups.com...
> Hi,
> I am new to MS-SQL and I have a problem. Actually I have made similar
> queries on Oracle, but now I failed on MS Sql. First of all I am using
> SQL Server 2005, but I think it is not that much important because my
> question is related something fundamental.
> I want to compare the result (which should be random) in one table,
> with another one in another table and if they are same, I want to check
> the other information. In both tables the column name is the same.
> So far I have tried:
>
> 1.
> SELECT TOP 1 pictureID FROM Pictures INNER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID()
> and got the error: Ambiguous column name 'pictureID'.
>
> 2.
> SELECT TOP 1 Pictures.pictureID FROM Pictures INNER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID()
> and got the error: There is no row at position 0.
>
> 3.
> SELECT TOP 1 Pictures.pictureID FROM Pictures LEFT OUTER JOIN Views ON
> Pictures.pictureID = Views.pictureID WHERE Pictures.active='Y' ORDER BY
> NEWID
> This query hasn't returned an error, but doesnt return the desired
> result.
>
> 4.
> SELECT TOP 1 Pictures.pictureID FROM Pictures, Views WHERE
> Pictures.pictureID = Views.pictureID AND Pictures.active='Y' ORDER BY
> NEWID()
> This query also hasn't returned an error, but doesnt return the desired
> result too.
>
> Thanks in advance for your help.
>
Monday, March 12, 2012
help needed on configure reporting service
report server: sql2005
remote database server: clustered server, sql2005
while configure on report server failed on the step:
create a grant scripts
with the error message:
System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
unavailable. (Exception from HRESULT: 0x800706BA)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts (Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
machine)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
dbServer)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
connectionString, String server, String database,
ConfigurationCredentialsType credsType, String account, String password,
Boolean upgrade, String dbVersion)
TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
set to 1 on the database srever. Also no firewall on the database server.
Any one have some hint on this one, any help is welcome.
ThanksWhat user are you using to run the services?
daw
"green hand" wrote:
> report server: sql2005
> remote database server: clustered server, sql2005
> while configure on report server failed on the step:
> create a grant scripts
> with the error message:
> System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> unavailable. (Exception from HRESULT: 0x800706BA)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementScope.InitializeGuts (Object o)
> at System.Management.ManagementScope.Initialize()
> at System.Management.ManagementObjectSearcher.Initialize()
> at System.Management.ManagementObjectSearcher.Get()
> at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> machine)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> dbServer)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> connectionString, String server, String database,
> ConfigurationCredentialsType credsType, String account, String password,
> Boolean upgrade, String dbVersion)
> TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> set to 1 on the database srever. Also no firewall on the database server.
> Any one have some hint on this one, any help is welcome.
> Thanks|||the user to run the RPC and to configure the report ingservice has the System
admin for the systme and database.
"daw" wrote:
> What user are you using to run the services?
> daw
> "green hand" wrote:
> > report server: sql2005
> > remote database server: clustered server, sql2005
> >
> > while configure on report server failed on the step:
> > create a grant scripts
> >
> > with the error message:
> > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > unavailable. (Exception from HRESULT: 0x800706BA)
> > at
> > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > errorCode, IntPtr errorInfo)
> > at System.Management.ManagementScope.InitializeGuts (Object o)
> > at System.Management.ManagementScope.Initialize()
> > at System.Management.ManagementObjectSearcher.Initialize()
> > at System.Management.ManagementObjectSearcher.Get()
> > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > machine)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > dbServer)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > connectionString, String server, String database,
> > ConfigurationCredentialsType credsType, String account, String password,
> > Boolean upgrade, String dbVersion)
> >
> > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > set to 1 on the database srever. Also no firewall on the database server.
> >
> > Any one have some hint on this one, any help is welcome.
> >
> > Thanks|||I'm not familiar with the problem, but hopefully one of these links will help:
http://support.microsoft.com/kb/224370
http://msdn2.microsoft.com/en-us/library/ms365170.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/09/22/473012.aspx
daw
"green hand" wrote:
> the user to run the RPC and to configure the report ingservice has the System
> admin for the systme and database.
> "daw" wrote:
> > What user are you using to run the services?
> >
> > daw
> >
> > "green hand" wrote:
> >
> > > report server: sql2005
> > > remote database server: clustered server, sql2005
> > >
> > > while configure on report server failed on the step:
> > > create a grant scripts
> > >
> > > with the error message:
> > > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > > unavailable. (Exception from HRESULT: 0x800706BA)
> > > at
> > > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > > errorCode, IntPtr errorInfo)
> > > at System.Management.ManagementScope.InitializeGuts (Object o)
> > > at System.Management.ManagementScope.Initialize()
> > > at System.Management.ManagementObjectSearcher.Initialize()
> > > at System.Management.ManagementObjectSearcher.Get()
> > > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > > machine)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > > dbServer)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > > connectionString, String server, String database,
> > > ConfigurationCredentialsType credsType, String account, String password,
> > > Boolean upgrade, String dbVersion)
> > >
> > > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > > set to 1 on the database srever. Also no firewall on the database server.
> > >
> > > Any one have some hint on this one, any help is welcome.
> > >
> > > Thanks
remote database server: clustered server, sql2005
while configure on report server failed on the step:
create a grant scripts
with the error message:
System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
unavailable. (Exception from HRESULT: 0x800706BA)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementScope.InitializeGuts (Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
machine)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
dbServer)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
connectionString, String server, String database,
ConfigurationCredentialsType credsType, String account, String password,
Boolean upgrade, String dbVersion)
TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
set to 1 on the database srever. Also no firewall on the database server.
Any one have some hint on this one, any help is welcome.
ThanksWhat user are you using to run the services?
daw
"green hand" wrote:
> report server: sql2005
> remote database server: clustered server, sql2005
> while configure on report server failed on the step:
> create a grant scripts
> with the error message:
> System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> unavailable. (Exception from HRESULT: 0x800706BA)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementScope.InitializeGuts (Object o)
> at System.Management.ManagementScope.Initialize()
> at System.Management.ManagementObjectSearcher.Initialize()
> at System.Management.ManagementObjectSearcher.Get()
> at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> machine)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> dbServer)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> connectionString, String server, String database,
> ConfigurationCredentialsType credsType, String account, String password,
> Boolean upgrade, String dbVersion)
> TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> set to 1 on the database srever. Also no firewall on the database server.
> Any one have some hint on this one, any help is welcome.
> Thanks|||the user to run the RPC and to configure the report ingservice has the System
admin for the systme and database.
"daw" wrote:
> What user are you using to run the services?
> daw
> "green hand" wrote:
> > report server: sql2005
> > remote database server: clustered server, sql2005
> >
> > while configure on report server failed on the step:
> > create a grant scripts
> >
> > with the error message:
> > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > unavailable. (Exception from HRESULT: 0x800706BA)
> > at
> > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > errorCode, IntPtr errorInfo)
> > at System.Management.ManagementScope.InitializeGuts (Object o)
> > at System.Management.ManagementScope.Initialize()
> > at System.Management.ManagementObjectSearcher.Initialize()
> > at System.Management.ManagementObjectSearcher.Get()
> > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > machine)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > dbServer)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > connectionString, String server, String database,
> > ConfigurationCredentialsType credsType, String account, String password,
> > Boolean upgrade, String dbVersion)
> >
> > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > set to 1 on the database srever. Also no firewall on the database server.
> >
> > Any one have some hint on this one, any help is welcome.
> >
> > Thanks|||I'm not familiar with the problem, but hopefully one of these links will help:
http://support.microsoft.com/kb/224370
http://msdn2.microsoft.com/en-us/library/ms365170.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/09/22/473012.aspx
daw
"green hand" wrote:
> the user to run the RPC and to configure the report ingservice has the System
> admin for the systme and database.
> "daw" wrote:
> > What user are you using to run the services?
> >
> > daw
> >
> > "green hand" wrote:
> >
> > > report server: sql2005
> > > remote database server: clustered server, sql2005
> > >
> > > while configure on report server failed on the step:
> > > create a grant scripts
> > >
> > > with the error message:
> > > System.Runtime.InteropServices.COMException (0x800706BA): The RPC server is
> > > unavailable. (Exception from HRESULT: 0x800706BA)
> > > at
> > > System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> > > errorCode, IntPtr errorInfo)
> > > at System.Management.ManagementScope.InitializeGuts (Object o)
> > > at System.Management.ManagementScope.Initialize()
> > > at System.Management.ManagementObjectSearcher.Initialize()
> > > at System.Management.ManagementObjectSearcher.Get()
> > > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses (String
> > > machine)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > > dbServer)
> > > at
> > > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > > connectionString, String server, String database,
> > > ConfigurationCredentialsType credsType, String account, String password,
> > > Boolean upgrade, String dbVersion)
> > >
> > > TCT/IP and name pipes is enabled, service RPC is started. 'remote access' is
> > > set to 1 on the database srever. Also no firewall on the database server.
> > >
> > > Any one have some hint on this one, any help is welcome.
> > >
> > > Thanks
Friday, March 9, 2012
Help Needed Disadter Recovery!
Our c drive has failed on our SQL Server following a major system crash!
We are going to have to re-install Windows and SQL Server.
Our backup failed last night.
When we re-install Windows we going to be able to see the drives in with our .mdf and .ldf file on them.
After we re-install sql server 2000 will we be able to run sp_dbattach to re-connect the mdf and ldf files?
Please help!
SimonYou will be able to atach database but if you had replication going on it will fail.
We are going to have to re-install Windows and SQL Server.
Our backup failed last night.
When we re-install Windows we going to be able to see the drives in with our .mdf and .ldf file on them.
After we re-install sql server 2000 will we be able to run sp_dbattach to re-connect the mdf and ldf files?
Please help!
SimonYou will be able to atach database but if you had replication going on it will fail.
Friday, February 24, 2012
Help me to fix this error
hi allServer Error in '/test' Application.
Exception Details:System.Data.SqlClient.SqlException: Cannot open database requested in login 'mehr'. Login fails. Login failed for user 'COMPUTER2\ASPNET'.
Source Error:
Source File:c:\inetpub\wwwroot\test\WebForm1.aspx.vb Line:69
Stack Trace:
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
thanks for your replyMeans user computer2/aspnet isnt a valid user in your database mehr. You either need to add the user, or add a different user to your connection string.
Nick
Server Error in '/test' Application.
Cannot open database requested in login 'mehr'. Login fails. Login failed for user 'COMPUTER2\ASPNET'.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details:System.Data.SqlClient.SqlException: Cannot open database requested in login 'mehr'. Login fails. Login failed for user 'COMPUTER2\ASPNET'.
Source Error:
|
Source File:c:\inetpub\wwwroot\test\WebForm1.aspx.vb Line:69
Stack Trace:
|
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
thanks for your replyMeans user computer2/aspnet isnt a valid user in your database mehr. You either need to add the user, or add a different user to your connection string.
Nick
Subscribe to:
Posts (Atom)