Can't start sql server 2000, error: "use sql 2005 management tools" !!!!

hi .everyone !

i have ms visual studio 2005 with sql sever 2005 management tools

anyway .. i want to use and install sql server 2000 in this machine .. i tried to install it, but when i tried to connect to the server .. it gives me this error:

"you must use sql server 2005 management tools to connect to this server"

can you help me ? plz !?

no one can help me ?

any suggestion ? help ? :(

Cant seem to modify a SQL Server 2000 Table Valued Function in SQL Server Management Studi

Hi
I cant seem to modify a SQL Server 2000 Table Valued Function through
SQL Server Management Studio (2005)
Has anyone else experienced this issue?
DicksterAny errors?
For me it works, make sure that the database is set up compatibility level
90
<grd@.renre.com> wrote in message
news:1160058691.080724.39850@.k70g2000cwa.googlegroups.com...
> Hi
> I cant seem to modify a SQL Server 2000 Table Valued Function through
> SQL Server Management Studio (2005)
> Has anyone else experienced this issue?
> Dickster
>|||grd@.renre.com wrote:
> Hi
> I cant seem to modify a SQL Server 2000 Table Valued Function through
> SQL Server Management Studio (2005)
> Has anyone else experienced this issue?
> Dickster
>
What do you mean by "can't seem to modify" ? If you execute the DDL
script (i.e. the "ALTER FUNCTION" or "CREATE FUNCTION" script), what
happens?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||> What do you mean by "can't seem to modify" ? If you execute the DDL
> script (i.e. the "ALTER FUNCTION" or "CREATE FUNCTION" script), what
> happens?
Tracy
I get the following error message
----
Property QuotedIdentifierStatus is not available for
UserDefinedFunciton '[bdo].[SplitCsvList]'. This property may not exist
for this object, or may not be retrievable due to insufficient access
rights (Microsoft.SqlServer.Smo)
----
NB: I am logged in as 'sa'
Dickster|||> What do you mean by "can't seem to modify" ? If you execute the DDL
> script (i.e. the "ALTER FUNCTION" or "CREATE FUNCTION" script), what
> happens?
>
Tracy
I right Mouse click on the Table Valued Function & Select 'Modify'
I get the following error message
----
Property QuotedIdentifierStatus is not available for
UserDefinedFunciton '[bdo].[SplitCsvList]'. This property may not exist
for this object, or may not be retrievable due to insufficient access
rights (Microsoft.SqlServer.Smo)
----
NB: I am logged in as 'sa'
Dickster|||Try without the GUI. ALTER FUNCTION. That would lead you to whether the problem is in the GUI or
server level. The GUI, however, will just pull out the source code from the system tables and slap
an ALTER FUNCITON around it and show that in a query window. So the problem seem to be getting at
the source code from SQL Servers meta-data views.
I ran a Profiler trace when right-clicking and selection Modify on a single statement table valued
function. Below seem to be the key parts. You can tru to modify the relevant parts in there and run
from a query window to see if that same error is returned.
Perhaps it is a compatibility level issue for the database?
SELECT
SCHEMA_NAME(udf.schema_id) AS [Schema],
udf.name AS [Name]
FROM
sys.all_objects AS udf
WHERE
(udf.type in ('TF', 'FN', 'IF', 'FS', 'FT'))and(udf.name=N'f' and SCHEMA_NAME(udf.schema_id)=N'dbo')
SELECT
udf.name AS [Name],
udf.object_id AS [ID],
udf.create_date AS [CreateDate],
udf.modify_date AS [DateLastModified],
SCHEMA_NAME(udf.schema_id) AS [Schema],
CAST(
case
when udf.is_ms_shipped = 1 then 1
when (
select
major_id
from
sys.extended_properties
where
major_id = udf.object_id and
minor_id = 0 and
class = 1 and
name = N'microsoft_database_tools_support')
is not null then 1
else 0
end
AS bit) AS [IsSystemObject],
usrt.name AS [DataType],
sret_param.name AS [DataTypeSchema],
ISNULL(baset.name, N'') AS [SystemType],
CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND ret_param.max_length <> -1 THEN
ret_param.max_length/2 ELSE ret_param.max_length END AS int) AS [Length],
CAST(ret_param.precision AS int) AS [NumericPrecision],
CAST(ret_param.scale AS int) AS [NumericScale],
ISNULL(xscret_param.name, N'') AS [XmlSchemaNamespace],
ISNULL(s2ret_param.name, N'') AS [XmlSchemaNamespaceSchema],
ISNULL( (case ret_param.is_xml_document when 1 then 2 else 1 end), 0) AS [XmlDocumentConstraint],
CAST(OBJECTPROPERTYEX(udf.object_id,N'ExecIsAnsiNullsOn') AS bit) AS [AnsiNullsStatus],
CAST(OBJECTPROPERTYEX(udf.object_id, N'IsSchemaBound') AS bit) AS [IsSchemaBound],
CAST(CASE WHEN ISNULL(smudf.definition, ssmudf.definition) IS NULL THEN 1 ELSE 0 END AS bit) AS
[IsEncrypted],
case when amudf.object_id is null then N'' else asmbludf.name end AS [AssemblyName],
case when amudf.object_id is null then N'' else amudf.assembly_class end AS [ClassName],
case when amudf.object_id is null then N'' else amudf.assembly_method end AS [MethodName],
CAST(case when amudf.object_id is null then CAST(smudf.null_on_null_input AS bit) else
amudf.null_on_null_input end AS bit) AS [ReturnsNullOnNullInput],
case when amudf.object_id is null then case isnull(smudf.execute_as_principal_id, -1) when -1 then 1
when -2 then 2 else 3 end else case isnull(amudf.execute_as_principal_id, -1) when -1 then 1 when -2
then 2 else 3 end end
AS [ExecutionContext],
case when amudf.object_id is null then ISNULL(user_name(smudf.execute_as_principal_id),N'') else
user_name(amudf.execute_as_principal_id) end AS [ExecutionContextPrincipal],
CAST(OBJECTPROPERTYEX(udf.object_id, N'IsDeterministic') AS bit) AS [IsDeterministic],
(case when 'FN' = udf.type then 1 when 'FS' = udf.type then 1 when 'IF' = udf.type then 3 when 'TF'
= udf.type then 2 when 'FT' = udf.type then 2 else 0 end) AS [FunctionType],
CASE WHEN udf.type IN ('FN','IF','TF') THEN 1 WHEN udf.type IN ('FS','FT') THEN 2 ELSE 1 END AS
[ImplementationType],
CAST(OBJECTPROPERTYEX(udf.object_id, N'IsQuotedIdentOn') AS bit) AS [QuotedIdentifierStatus],
ret_param.name AS [TableVariableName],
ISNULL(smudf.definition, ssmudf.definition) AS [Definition]
FROM
sys.all_objects AS udf
LEFT OUTER JOIN sys.all_parameters AS ret_param ON ret_param.object_id = udf.object_id and
ret_param.is_output = 1
LEFT OUTER JOIN sys.types AS usrt ON usrt.user_type_id = ret_param.user_type_id
LEFT OUTER JOIN sys.schemas AS sret_param ON sret_param.schema_id = usrt.schema_id
LEFT OUTER JOIN sys.types AS baset ON baset.user_type_id = ret_param.system_type_id and
baset.user_type_id = baset.system_type_id
LEFT OUTER JOIN sys.xml_schema_collections AS xscret_param ON xscret_param.xml_collection_id =ret_param.xml_collection_id
LEFT OUTER JOIN sys.schemas AS s2ret_param ON s2ret_param.schema_id = xscret_param.schema_id
LEFT OUTER JOIN sys.sql_modules AS smudf ON smudf.object_id = udf.object_id
LEFT OUTER JOIN sys.system_sql_modules AS ssmudf ON ssmudf.object_id = udf.object_id
LEFT OUTER JOIN sys.assembly_modules AS amudf ON amudf.object_id = udf.object_id
LEFT OUTER JOIN sys.assemblies AS asmbludf ON asmbludf.assembly_id = amudf.assembly_id
WHERE
(udf.type in ('TF', 'FN', 'IF', 'FS', 'FT'))and(udf.name=N'f' and SCHEMA_NAME(udf.schema_id)=N'dbo')
SELECT
NULL AS [Text],
ISNULL(smudf.definition, ssmudf.definition) AS [Definition]
FROM
sys.all_objects AS udf
LEFT OUTER JOIN sys.sql_modules AS smudf ON smudf.object_id = udf.object_id
LEFT OUTER JOIN sys.system_sql_modules AS ssmudf ON ssmudf.object_id = udf.object_id
WHERE
(udf.type in ('TF', 'FN', 'IF', 'FS', 'FT'))and(udf.name=N'f' and SCHEMA_NAME(udf.schema_id)=N'dbo')
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<grd@.renre.com> wrote in message news:1160069137.082636.156350@.k70g2000cwa.googlegroups.com...
>> What do you mean by "can't seem to modify" ? If you execute the DDL
>> script (i.e. the "ALTER FUNCTION" or "CREATE FUNCTION" script), what
>> happens?
>
> Tracy
> I right Mouse click on the Table Valued Function & Select 'Modify'
> I get the following error message
> ----
> Property QuotedIdentifierStatus is not available for
> UserDefinedFunciton '[bdo].[SplitCsvList]'. This property may not exist
> for this object, or may not be retrievable due to insufficient access
> rights (Microsoft.SqlServer.Smo)
> ----
> NB: I am logged in as 'sa'
> Dickster
>|||grd@.renre.com wrote:
>> What do you mean by "can't seem to modify" ? If you execute the DDL
>> script (i.e. the "ALTER FUNCTION" or "CREATE FUNCTION" script), what
>> happens?
> Tracy
> I get the following error message
> ----
> Property QuotedIdentifierStatus is not available for
> UserDefinedFunciton '[bdo].[SplitCsvList]'. This property may not exist
> for this object, or may not be retrievable due to insufficient access
> rights (Microsoft.SqlServer.Smo)
> ----
> NB: I am logged in as 'sa'
> Dickster
>
This is a known bug...
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126099
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thanks for your reply Tracy and to all others who replied.
Dickster

can't see DB on SQL 2005 with SQL management studio

I am having a strange issue with SQL Management studio express. I can
log via the front end, but I do not see the DB for which this user is
"owner"
This is not the odd part. The odd part is that if I log in through a
3rd party front end such as EMS sql manager lite I do see the database
I own, and can manipulate it as I please. Can anyone suggest a reason
for this. Here are details of the setup just in case. The DB server
only has one DB other then the default system DB's. The owner of the db
I am having issue with has full permissions on the DB, but is not a
member of ANY server roles. There is a firewall on the machine but it
is allowing tcp connections on 1433. I have not set any connection
restrictions. The only major security change done on the server was to
use:
use master
Revoke View any database from public
go
AND
use *db I am working with*
Exec Sp_changedbowner ' *user that will own the db I am working with* '
Hi
Have you logged out/in since changing the owner of the database? Have you
tried to create a new database as that login, and can you see it? Have you
applied SP1?
John
"pr0f1t" wrote:

> I am having a strange issue with SQL Management studio express. I can
> log via the front end, but I do not see the DB for which this user is
> "owner"
> This is not the odd part. The odd part is that if I log in through a
> 3rd party front end such as EMS sql manager lite I do see the database
> I own, and can manipulate it as I please. Can anyone suggest a reason
> for this. Here are details of the setup just in case. The DB server
> only has one DB other then the default system DB's. The owner of the db
> I am having issue with has full permissions on the DB, but is not a
> member of ANY server roles. There is a firewall on the machine but it
> is allowing tcp connections on 1433. I have not set any connection
> restrictions. The only major security change done on the server was to
> use:
> use master
> Revoke View any database from public
> go
> AND
> use *db I am working with*
> Exec Sp_changedbowner ' *user that will own the db I am working with* '
>
|||that is a fantastic suggestion. I don't knwo why I did not try this
first. Yes the new DB is visible if I make this user owner. So why is
the origional DB not visible if this user is owner of that as well? Any
thoughts
John Bell wrote:[vbcol=seagreen]
> Hi
> Have you logged out/in since changing the owner of the database? Have you
> tried to create a new database as that login, and can you see it? Have you
> applied SP1?
> John
> "pr0f1t" wrote:
|||that is a fantastic suggestion. I don't knwo why I did not try this
first. Yes the new DB is visible if I make this user owner. So why is
the origional DB not visible if this user is owner of that as well? Any
thoughts
|||Hi
That sounds like the change of ownership has not been reflected in the other
database. For the new database did you create the database as the login or
change the database to be owned by the login?
If you log in as a sysadm you should be able to see that database?
Try changing the owner again to a different login and then change it back.
If you run SELECT * FROM master.sys.databases what does it return?
Try regranting the VIEW ALL DATABASES to public and then just deny it to
specific logins.
What version of SQL 2005 are you using?
John
"pr0f1t" wrote:

> that is a fantastic suggestion. I don't knwo why I did not try this
> first. Yes the new DB is visible if I make this user owner. So why is
> the origional DB not visible if this user is owner of that as well? Any
> thoughts
>
> John Bell wrote:
>
|||*dbname*5NULL0xC1F615C4866765479D8B0AD5FD9FDEAA2006-10-31
14:53:43.06080SQL_Latin1_General_CP1_CI_AS0MULTI_USER0000ONLINE0000OFF03SIMPLE1TORN_PAGE_DETECTION1100000000000000000000009063F0BE-B2B1-4A45-9036-8775AAB1B47A00NOTHING0
is the result of SELECT * FROM master.sys.databases
I am running SQL Server 9.0.2047. I tried to change the ownership of
the DB but it only results in errors pretaining to object and schema
ownershipo, but I cannot seem to change the ownership to another user.
Ifs there a way to do this with TSQL? I have one user that essentially
needs to hve ownership of the DB, and access via a front end
porefereably Microsoft SQL managment studio express.
John Bell wrote:
|||Hi
Can you post the exact error number and message that occurs when you try to
change the owner? I assume you are using sp_changedbowner to do this?
Try creating a new user and changing the schema ownership to them
John
"pr0f1t" wrote:

> *dbname*5NULL0xC1F615C4866765479D8B0AD5FD9FDEAA2006-10-31
> 14:53:43.06080SQL_Latin1_General_CP1_CI_AS0MULTI_USER0000ONLINE0000OFF03SIMPLE1TORN_PAGE_DETECTION1100000000000000000000009063F0BE-B2B1-4A45-9036-8775AAB1B47A00NOTHING0
>
> is the result of SELECT * FROM master.sys.databases
> I am running SQL Server 9.0.2047. I tried to change the ownership of
> the DB but it only results in errors pretaining to object and schema
> ownershipo, but I cannot seem to change the ownership to another user.
> Ifs there a way to do this with TSQL? I have one user that essentially
> needs to hve ownership of the DB, and access via a front end
> porefereably Microsoft SQL managment studio express.
>
> John Bell wrote:
>

can't see DB on SQL 2005 with SQL management studio

I am having a strange issue with SQL Management studio express. I can
log via the front end, but I do not see the DB for which this user is
"owner"
This is not the odd part. The odd part is that if I log in through a
3rd party front end such as EMS sql manager lite I do see the database
I own, and can manipulate it as I please. Can anyone suggest a reason
for this. Here are details of the setup just in case. The DB server
only has one DB other then the default system DB's. The owner of the db
I am having issue with has full permissions on the DB, but is not a
member of ANY server roles. There is a firewall on the machine but it
is allowing tcp connections on 1433. I have not set any connection
restrictions. The only major security change done on the server was to
use:
use master
Revoke View any database from public
go
AND
use *db I am working with*
Exec Sp_changedbowner ' *user that will own the db I am working with* 'Hi
Have you logged out/in since changing the owner of the database? Have you
tried to create a new database as that login, and can you see it? Have you
applied SP1?
John
"pr0f1t" wrote:

> I am having a strange issue with SQL Management studio express. I can
> log via the front end, but I do not see the DB for which this user is
> "owner"
> This is not the odd part. The odd part is that if I log in through a
> 3rd party front end such as EMS sql manager lite I do see the database
> I own, and can manipulate it as I please. Can anyone suggest a reason
> for this. Here are details of the setup just in case. The DB server
> only has one DB other then the default system DB's. The owner of the db
> I am having issue with has full permissions on the DB, but is not a
> member of ANY server roles. There is a firewall on the machine but it
> is allowing tcp connections on 1433. I have not set any connection
> restrictions. The only major security change done on the server was to
> use:
> use master
> Revoke View any database from public
> go
> AND
> use *db I am working with*
> Exec Sp_changedbowner ' *user that will own the db I am working with* '
>|||that is a fantastic suggestion. I don't knwo why I did not try this
first. Yes the new DB is visible if I make this user owner. So why is
the origional DB not visible if this user is owner of that as well? Any
thoughts
John Bell wrote:[vbcol=seagreen]
> Hi
> Have you logged out/in since changing the owner of the database? Have you
> tried to create a new database as that login, and can you see it? Have you
> applied SP1?
> John
> "pr0f1t" wrote:
>|||that is a fantastic suggestion. I don't knwo why I did not try this
first. Yes the new DB is visible if I make this user owner. So why is
the origional DB not visible if this user is owner of that as well? Any
thoughts|||Hi
That sounds like the change of ownership has not been reflected in the other
database. For the new database did you create the database as the login or
change the database to be owned by the login?
If you log in as a sysadm you should be able to see that database?
Try changing the owner again to a different login and then change it back.
If you run SELECT * FROM master.sys.databases what does it return?
Try regranting the VIEW ALL DATABASES to public and then just deny it to
specific logins.
What version of SQL 2005 are you using?
John
"pr0f1t" wrote:

> that is a fantastic suggestion. I don't knwo why I did not try this
> first. Yes the new DB is visible if I make this user owner. So why is
> the origional DB not visible if this user is owner of that as well? Any
> thoughts
>
> John Bell wrote:
>|||*dbname* 5 NULL 0xC1F615C4866765479D8B0A
D5FD9FDEAA 2006-10-31
14:53:43. 060 80 SQL_Latin1_General_CP1_CI_AS 0 MU
LTI_USER 0 0 0 0 ONLINE 0 0
0 0 OFF 0 3 SIMPLE 1 TORN_PAGE_DETECTIO
N 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 9063F0BE-B2B1-4A45-9036-8775AAB1B47A 0 0 NOTHING 0
is the result of SELECT * FROM master.sys.databases
I am running SQL Server 9.0.2047. I tried to change the ownership of
the DB but it only results in errors pretaining to object and schema
ownershipo, but I cannot seem to change the ownership to another user.
Ifs there a way to do this with TSQL? I have one user that essentially
needs to hve ownership of the DB, and access via a front end
porefereably Microsoft SQL managment studio express.
John Bell wrote:|||Hi
Can you post the exact error number and message that occurs when you try to
change the owner? I assume you are using sp_changedbowner to do this?
Try creating a new user and changing the schema ownership to them
John
"pr0f1t" wrote:

> *dbname* 5 NULL 0xC1F615C4866765479D8B0A
D5FD9FDEAA 2006-10-31
> 14:53:43. 060 80 SQL_Latin1_General_CP1_CI_AS 0 MU
LTI_USER 0 0 0 0 ONLINE 0
0 0 0 OFF 0 3 SIMPLE 1 TORN_PAGE_DETECT
ION 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 9063F0BE-B2B1-4A45-9036-8775AAB1B47A 0 0 NOTHING 0
>
> is the result of SELECT * FROM master.sys.databases
> I am running SQL Server 9.0.2047. I tried to change the ownership of
> the DB but it only results in errors pretaining to object and schema
> ownershipo, but I cannot seem to change the ownership to another user.
> Ifs there a way to do this with TSQL? I have one user that essentially
> needs to hve ownership of the DB, and access via a front end
> porefereably Microsoft SQL managment studio express.
>
> John Bell wrote:
>

can't see DB on SQL 2005 with SQL management studio

I am having a strange issue with SQL Management studio express. I can
log via the front end, but I do not see the DB for which this user is
"owner"
This is not the odd part. The odd part is that if I log in through a
3rd party front end such as EMS sql manager lite I do see the database
I own, and can manipulate it as I please. Can anyone suggest a reason
for this. Here are details of the setup just in case. The DB server
only has one DB other then the default system DB's. The owner of the db
I am having issue with has full permissions on the DB, but is not a
member of ANY server roles. There is a firewall on the machine but it
is allowing tcp connections on 1433. I have not set any connection
restrictions. The only major security change done on the server was to
use:
use master
Revoke View any database from public
go
AND
use *db I am working with*
Exec Sp_changedbowner ' *user that will own the db I am working with* 'Hi
Have you logged out/in since changing the owner of the database? Have you
tried to create a new database as that login, and can you see it? Have you
applied SP1?
John
"pr0f1t" wrote:
> I am having a strange issue with SQL Management studio express. I can
> log via the front end, but I do not see the DB for which this user is
> "owner"
> This is not the odd part. The odd part is that if I log in through a
> 3rd party front end such as EMS sql manager lite I do see the database
> I own, and can manipulate it as I please. Can anyone suggest a reason
> for this. Here are details of the setup just in case. The DB server
> only has one DB other then the default system DB's. The owner of the db
> I am having issue with has full permissions on the DB, but is not a
> member of ANY server roles. There is a firewall on the machine but it
> is allowing tcp connections on 1433. I have not set any connection
> restrictions. The only major security change done on the server was to
> use:
> use master
> Revoke View any database from public
> go
> AND
> use *db I am working with*
> Exec Sp_changedbowner ' *user that will own the db I am working with* '
>|||that is a fantastic suggestion. I don't knwo why I did not try this
first. Yes the new DB is visible if I make this user owner. So why is
the origional DB not visible if this user is owner of that as well? Any
thoughts
John Bell wrote:
> Hi
> Have you logged out/in since changing the owner of the database? Have you
> tried to create a new database as that login, and can you see it? Have you
> applied SP1?
> John
> "pr0f1t" wrote:
> > I am having a strange issue with SQL Management studio express. I can
> > log via the front end, but I do not see the DB for which this user is
> > "owner"
> > This is not the odd part. The odd part is that if I log in through a
> > 3rd party front end such as EMS sql manager lite I do see the database
> > I own, and can manipulate it as I please. Can anyone suggest a reason
> > for this. Here are details of the setup just in case. The DB server
> > only has one DB other then the default system DB's. The owner of the db
> > I am having issue with has full permissions on the DB, but is not a
> > member of ANY server roles. There is a firewall on the machine but it
> > is allowing tcp connections on 1433. I have not set any connection
> > restrictions. The only major security change done on the server was to
> > use:
> >
> > use master
> > Revoke View any database from public
> > go
> >
> > AND
> >
> > use *db I am working with*
> > Exec Sp_changedbowner ' *user that will own the db I am working with* '
> >
> >|||that is a fantastic suggestion. I don't knwo why I did not try this
first. Yes the new DB is visible if I make this user owner. So why is
the origional DB not visible if this user is owner of that as well? Any
thoughts|||Hi
That sounds like the change of ownership has not been reflected in the other
database. For the new database did you create the database as the login or
change the database to be owned by the login?
If you log in as a sysadm you should be able to see that database?
Try changing the owner again to a different login and then change it back.
If you run SELECT * FROM master.sys.databases what does it return?
Try regranting the VIEW ALL DATABASES to public and then just deny it to
specific logins.
What version of SQL 2005 are you using?
John
"pr0f1t" wrote:
> that is a fantastic suggestion. I don't knwo why I did not try this
> first. Yes the new DB is visible if I make this user owner. So why is
> the origional DB not visible if this user is owner of that as well? Any
> thoughts
>
> John Bell wrote:
> > Hi
> >
> > Have you logged out/in since changing the owner of the database? Have you
> > tried to create a new database as that login, and can you see it? Have you
> > applied SP1?
> >
> > John
> >
> > "pr0f1t" wrote:
> >
> > > I am having a strange issue with SQL Management studio express. I can
> > > log via the front end, but I do not see the DB for which this user is
> > > "owner"
> > > This is not the odd part. The odd part is that if I log in through a
> > > 3rd party front end such as EMS sql manager lite I do see the database
> > > I own, and can manipulate it as I please. Can anyone suggest a reason
> > > for this. Here are details of the setup just in case. The DB server
> > > only has one DB other then the default system DB's. The owner of the db
> > > I am having issue with has full permissions on the DB, but is not a
> > > member of ANY server roles. There is a firewall on the machine but it
> > > is allowing tcp connections on 1433. I have not set any connection
> > > restrictions. The only major security change done on the server was to
> > > use:
> > >
> > > use master
> > > Revoke View any database from public
> > > go
> > >
> > > AND
> > >
> > > use *db I am working with*
> > > Exec Sp_changedbowner ' *user that will own the db I am working with* '
> > >
> > >
>|||*dbname* 5 NULL 0xC1F615C4866765479D8B0AD5FD9FDEAA 2006-10-31
14:53:43.060 80 SQL_Latin1_General_CP1_CI_AS 0 MULTI_USER 0 0 0 0 ONLINE 0 0 0 0 OFF 0 3 SIMPLE 1 TORN_PAGE_DETECTION 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9063F0BE-B2B1-4A45-9036-8775AAB1B47A 0 0 NOTHING 0
is the result of SELECT * FROM master.sys.databases
I am running SQL Server 9.0.2047. I tried to change the ownership of
the DB but it only results in errors pretaining to object and schema
ownershipo, but I cannot seem to change the ownership to another user.
Ifs there a way to do this with TSQL? I have one user that essentially
needs to hve ownership of the DB, and access via a front end
porefereably Microsoft SQL managment studio express.
John Bell wrote:|||Hi
Can you post the exact error number and message that occurs when you try to
change the owner? I assume you are using sp_changedbowner to do this?
Try creating a new user and changing the schema ownership to them
John
"pr0f1t" wrote:
> *dbname* 5 NULL 0xC1F615C4866765479D8B0AD5FD9FDEAA 2006-10-31
> 14:53:43.060 80 SQL_Latin1_General_CP1_CI_AS 0 MULTI_USER 0 0 0 0 ONLINE 0 0 0 0 OFF 0 3 SIMPLE 1 TORN_PAGE_DETECTION 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 9063F0BE-B2B1-4A45-9036-8775AAB1B47A 0 0 NOTHING 0
>
> is the result of SELECT * FROM master.sys.databases
> I am running SQL Server 9.0.2047. I tried to change the ownership of
> the DB but it only results in errors pretaining to object and schema
> ownershipo, but I cannot seem to change the ownership to another user.
> Ifs there a way to do this with TSQL? I have one user that essentially
> needs to hve ownership of the DB, and access via a front end
> porefereably Microsoft SQL managment studio express.
>
> John Bell wrote:
>

Cant see Db created inside VS 2005?

When I create a new Sql Sever 2005 express database inside of the VS 2005 Pro IDE I cant see the database from the Management Tool (Sql Srvr Express Management Studio). Is this normal? I can "attach" it and see it, but I wanted to make sure my environment was working correctly.

Thanks in advance for any input.

Tim

Hi there,

As far as I am aware, this is the correct behaviour. From memory, the databases you create via the IDE are basically local to the project you created them in.

However, as you have discovered, these are still standard .mdf and .ldf files and can be attached as to be visible as one of the database on your SQL Server Express instance.

Hope that helps a bit or sheds some light on things, but sorry if it doesn't
|||

To be clear, when you create a database in VS using Add | New Item | Database, it is an embedded project database as Nate suggests. This database uses a User Instance connection to manage auto-attaching the database to the application at runtime.

If you turn around and manually attach the database to the main instance of SQL Express, you application will fail when you run it as it will attempt to auto-attach the database to the User Instance, but the file will be locked so it won't be attachable within the application.

There are a number of discussions already in the forums and a white paper about User Instances if you want more info.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Can't save Server names in "Object Explorer"

In Management Studio, under Registered Servers, I double-click a server name (could be sql 2000 or sql 2005 server) and it apperars in "Object Explorer" where I can work with it. I click the "Save All" button in Management Studio, exit Studio, and re-start Studio. When I do, I find that all the servers I placed under "Object Explorer" are now missing and I need to go through the "double-click the registered server" ritual again. And again, and again.

What am I doing wrong here? Why don't the servers "stick" in Object Explorer?

TIA

barkingdog

P.S. I have Sql 2005 SP1 installed on my box.

When the server is listed under Object Explorer you've got an active connection to that server. You probably don't want to open active connections to each of your servers every time you run Management Studio.

If you don't already have the window open, go to the View menu and open up the Registered Servers window. I keep that one open, and double-click a server in that window when I need to connect to perform some maintenance on the server. It pops right up in the Object Explorer window and I'm ready to work.

|||>>>

When the server is listed under Object Explorer you've got an active connection to that server.

Thanks for the reply. It makes sense but I sure didn't think of it myself.

Three barks and a tail wave

Barkingdog

Can't re-submit a deleted conflicted row

Hello,
I have a merge replication which use identity range management (for some
tables).
I have a table that inserted a row on the publisher and tried to transfer it
to subscriber. The subscriber got an error when trying to insert it (by the
way, I use MSDE on subscriber and MSmerge_contents and MSmerge_tombstone are
huge and the DB limit of 2 GB arrive fast - it was nice that the system
tables are not included in the 2 GB limit... I decided to move that 2 tables
in another DB and it works nice). As I said, the subscriber gave an error
(different reasons) and the conflict resolver decided to delete the row from
publisher, because it can't insert in on subscriber !?! Anyway seems to be ok
because the row i have in conflict viewer, that seems that I can re-insert
it. But when I try to re-insert it, it gave me an error because the identity
ranges changed and the old value (of deleted row) is not proper for the new
constraints of identity... I supposed that SQL will deactivate the
constraint, as it does during replication...
Any ideea how to re-insert it? Or I have to "manually" (programatically)
de-activate it, insert it from conflict table and re-activate it?
Thanks for any suugestion.
Catalin
Hello Catalin,
I have something for you. I've tried reaching you through phone or email,
without success. Email me at chris lafrance at h_tm__l dot com.
Cheers
"Catalin NASTAC" wrote:

> Hello,
> I have a merge replication which use identity range management (for some
> tables).
> I have a table that inserted a row on the publisher and tried to transfer it
> to subscriber. The subscriber got an error when trying to insert it (by the
> way, I use MSDE on subscriber and MSmerge_contents and MSmerge_tombstone are
> huge and the DB limit of 2 GB arrive fast - it was nice that the system
> tables are not included in the 2 GB limit... I decided to move that 2 tables
> in another DB and it works nice). As I said, the subscriber gave an error
> (different reasons) and the conflict resolver decided to delete the row from
> publisher, because it can't insert in on subscriber !?! Anyway seems to be ok
> because the row i have in conflict viewer, that seems that I can re-insert
> it. But when I try to re-insert it, it gave me an error because the identity
> ranges changed and the old value (of deleted row) is not proper for the new
> constraints of identity... I supposed that SQL will deactivate the
> constraint, as it does during replication...
> Any ideea how to re-insert it? Or I have to "manually" (programatically)
> de-activate it, insert it from conflict table and re-activate it?
> Thanks for any suugestion.
> Catalin

cant register sql2k5

I have a local instance of sql2k5, as well as a remote one. From my local
Management Studio, I try to register the remote one, and I get the message...
A connection was successfully established to the server, but then an error
occured during the login process. (provider: TCP Provider, error:0 - An
existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
10054)
Any ideas?
--
TIA,
ChrisRDid you enable TCP/IP connections from remote machines in SQL Surface
Area Configuration Tool? They're not turned on by default in 2005.
ChrisR wrote:
> I have a local instance of sql2k5, as well as a remote one. From my local
> Management Studio, I try to register the remote one, and I get the message...
> A connection was successfully established to the server, but then an error
> occured during the login process. (provider: TCP Provider, error:0 - An
> existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> 10054)
> Any ideas?
> --
> TIA,
> ChrisR|||I don't have a Configurations tab on the remote box... I just realized its
Beta2. Could this have sometihng to do with it?
--
TIA,
ChrisR
"Corey Bunch" wrote:
> Did you enable TCP/IP connections from remote machines in SQL Surface
> Area Configuration Tool? They're not turned on by default in 2005.
> ChrisR wrote:
> > I have a local instance of sql2k5, as well as a remote one. From my local
> > Management Studio, I try to register the remote one, and I get the message...
> >
> > A connection was successfully established to the server, but then an error
> > occured during the login process. (provider: TCP Provider, error:0 - An
> > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > 10054)
> >
> > Any ideas?
> > --
> > TIA,
> > ChrisR
>|||Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
Configuration tool?
"ChrisR" wrote:
> I don't have a Configurations tab on the remote box... I just realized its
> Beta2. Could this have sometihng to do with it?
> --
> TIA,
> ChrisR
>
> "Corey Bunch" wrote:
> > Did you enable TCP/IP connections from remote machines in SQL Surface
> > Area Configuration Tool? They're not turned on by default in 2005.
> >
> > ChrisR wrote:
> > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > Management Studio, I try to register the remote one, and I get the message...
> > >
> > > A connection was successfully established to the server, but then an error
> > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > 10054)
> > >
> > > Any ideas?
> > > --
> > > TIA,
> > > ChrisR
> >
> >|||Start\ Programs\ there is no Configuration Tools option.
--
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
--
TIA,
ChrisR
"ChrisR" wrote:
> Start\ Programs\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "burt_king" wrote:
> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> > Configuration tool?
> >
> > "ChrisR" wrote:
> >
> > > I don't have a Configurations tab on the remote box... I just realized its
> > > Beta2. Could this have sometihng to do with it?
> > > --
> > > TIA,
> > > ChrisR
> > >
> > >
> > > "Corey Bunch" wrote:
> > >
> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > > Area Configuration Tool? They're not turned on by default in 2005.
> > > >
> > > > ChrisR wrote:
> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > > Management Studio, I try to register the remote one, and I get the message...
> > > > >
> > > > > A connection was successfully established to the server, but then an error
> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > > 10054)
> > > > >
> > > > > Any ideas?
> > > > > --
> > > > > TIA,
> > > > > ChrisR
> > > >
> > > >|||How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
you can enable the netlibs.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> --
> TIA,
> ChrisR
>
> "ChrisR" wrote:
>> Start\ Programs\ there is no Configuration Tools option.
>> --
>> TIA,
>> ChrisR
>>
>> "burt_king" wrote:
>> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> > Configuration tool?
>> >
>> > "ChrisR" wrote:
>> >
>> > > I don't have a Configurations tab on the remote box... I just realized its
>> > > Beta2. Could this have sometihng to do with it?
>> > > --
>> > > TIA,
>> > > ChrisR
>> > >
>> > >
>> > > "Corey Bunch" wrote:
>> > >
>> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> > > >
>> > > > ChrisR wrote:
>> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> > > > > Management Studio, I try to register the remote one, and I get the message...
>> > > > >
>> > > > > A connection was successfully established to the server, but then an error
>> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> > > > > 10054)
>> > > > >
>> > > > > Any ideas?
>> > > > > --
>> > > > > TIA,
>> > > > > ChrisR
>> > > >
>> > > >|||And do what to the netlibs? I dont see anything like enable remote connections.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> How about Computer Manager, under Services, you should have some SQL Server Configuration Node. Here
> you can enable the netlibs.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "ChrisR" wrote:
> >
> >> Start\ Programs\ there is no Configuration Tools option.
> >> --
> >> TIA,
> >> ChrisR
> >>
> >>
> >> "burt_king" wrote:
> >>
> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> > Configuration tool?
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> > > Beta2. Could this have sometihng to do with it?
> >> > > --
> >> > > TIA,
> >> > > ChrisR
> >> > >
> >> > >
> >> > > "Corey Bunch" wrote:
> >> > >
> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> > > >
> >> > > > ChrisR wrote:
> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> > > > >
> >> > > > > A connection was successfully established to the server, but then an error
> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> > > > > 10054)
> >> > > > >
> >> > > > > Any ideas?
> >> > > > > --
> >> > > > > TIA,
> >> > > > > ChrisR
> >> > > >
> >> > > >
>|||Also, I tried to register in reverse.
1; In my local box, I went into
I logged into the remote box and tried to register my local box. I went into
SQL Server Surface Area Config/ Services and Connections/ Remote Connections/
Local and Remote Connections is checked.
When I try to register it says Unknown ProviderConnection string is invalid.
(MSSQL error: 87)
TIA,
ChrisR
"burt_king" wrote:
> Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> Configuration tool?
> "ChrisR" wrote:
> > I don't have a Configurations tab on the remote box... I just realized its
> > Beta2. Could this have sometihng to do with it?
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Corey Bunch" wrote:
> >
> > > Did you enable TCP/IP connections from remote machines in SQL Surface
> > > Area Configuration Tool? They're not turned on by default in 2005.
> > >
> > > ChrisR wrote:
> > > > I have a local instance of sql2k5, as well as a remote one. From my local
> > > > Management Studio, I try to register the remote one, and I get the message...
> > > >
> > > > A connection was successfully established to the server, but then an error
> > > > occured during the login process. (provider: TCP Provider, error:0 - An
> > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> > > > 10054)
> > > >
> > > > Any ideas?
> > > > --
> > > > TIA,
> > > > ChrisR
> > >
> > >|||Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
the following folder structure:
SQL Server Configuration Manager
SQL Server 2005 Network Configuration
Protocols for [instancename]
In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> And do what to the netlibs? I dont see anything like enable remote connections.
> --
> TIA,
> ChrisR
>
> "Tibor Karaszi" wrote:
>> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
>> Here
>> you can enable the netlibs.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
>> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
>> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
>> >
>> > --
>> > TIA,
>> > ChrisR
>> >
>> >
>> > "ChrisR" wrote:
>> >
>> >> Start\ Programs\ there is no Configuration Tools option.
>> >> --
>> >> TIA,
>> >> ChrisR
>> >>
>> >>
>> >> "burt_king" wrote:
>> >>
>> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
>> >> > Configuration tool?
>> >> >
>> >> > "ChrisR" wrote:
>> >> >
>> >> > > I don't have a Configurations tab on the remote box... I just realized its
>> >> > > Beta2. Could this have sometihng to do with it?
>> >> > > --
>> >> > > TIA,
>> >> > > ChrisR
>> >> > >
>> >> > >
>> >> > > "Corey Bunch" wrote:
>> >> > >
>> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
>> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
>> >> > > >
>> >> > > > ChrisR wrote:
>> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
>> >> > > > > Management Studio, I try to register the remote one, and I get the message...
>> >> > > > >
>> >> > > > > A connection was successfully established to the server, but then an error
>> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
>> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
>> >> > > > > 10054)
>> >> > > > >
>> >> > > > > Any ideas?
>> >> > > > > --
>> >> > > > > TIA,
>> >> > > > > ChrisR
>> >> > > >
>> >> > > >
>>|||Im going to reinstall with a more current version and see what happens.
--
TIA,
ChrisR
"Tibor Karaszi" wrote:
> Hard to know what your setup look like as you are on an older version (beta). On my machines, I use
> the following folder structure:
> SQL Server Configuration Manager
> SQL Server 2005 Network Configuration
> Protocols for [instancename]
> In above folder I can right-click a netlib (TCP/IP, for instance) and enable it.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:F19474D2-3815-4B06-B549-FE357816A8C9@.microsoft.com...
> > And do what to the netlibs? I dont see anything like enable remote connections.
> >
> > --
> > TIA,
> > ChrisR
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> How about Computer Manager, under Services, you should have some SQL Server Configuration Node.
> >> Here
> >> you can enable the netlibs.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> >> news:0AA1654F-9449-484F-9CCA-AC7472FEF91B@.microsoft.com...
> >> > Sorry... start\programs\sql2k5\ there is no Configuration Tools option.
> >> >
> >> > --
> >> > TIA,
> >> > ChrisR
> >> >
> >> >
> >> > "ChrisR" wrote:
> >> >
> >> >> Start\ Programs\ there is no Configuration Tools option.
> >> >> --
> >> >> TIA,
> >> >> ChrisR
> >> >>
> >> >>
> >> >> "burt_king" wrote:
> >> >>
> >> >> > Are you looking under Programs\SQL 2005\Configuration Tools\Surface Area
> >> >> > Configuration tool?
> >> >> >
> >> >> > "ChrisR" wrote:
> >> >> >
> >> >> > > I don't have a Configurations tab on the remote box... I just realized its
> >> >> > > Beta2. Could this have sometihng to do with it?
> >> >> > > --
> >> >> > > TIA,
> >> >> > > ChrisR
> >> >> > >
> >> >> > >
> >> >> > > "Corey Bunch" wrote:
> >> >> > >
> >> >> > > > Did you enable TCP/IP connections from remote machines in SQL Surface
> >> >> > > > Area Configuration Tool? They're not turned on by default in 2005.
> >> >> > > >
> >> >> > > > ChrisR wrote:
> >> >> > > > > I have a local instance of sql2k5, as well as a remote one. From my local
> >> >> > > > > Management Studio, I try to register the remote one, and I get the message...
> >> >> > > > >
> >> >> > > > > A connection was successfully established to the server, but then an error
> >> >> > > > > occured during the login process. (provider: TCP Provider, error:0 - An
> >> >> > > > > existing connection was forcibly closed by the remote host. ) (MSSQL, Error:
> >> >> > > > > 10054)
> >> >> > > > >
> >> >> > > > > Any ideas?
> >> >> > > > > --
> >> >> > > > > TIA,
> >> >> > > > > ChrisR
> >> >> > > >
> >> >> > > >
> >>
> >>
>

Can't register SQL Server 2000 database with 2005 Management Studio

I was told (by a Microsoft architect) that this works, but can't find any documentation or any clues within Management Studio.

The only way I can see to register a database is to make it a "Database Engine" (whatever that is). I give it a server name and SQL Server login. Error is:

TITLE: Connect to Server

Cannot connect to <servername>.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

BUTTONS:

OK

Mark,

I'm going to move this thread to the Tools General forum where I think you'll get a faster response.

-Jeffrey

|||Make sure that the server is reachable from the machine and that it is using the default port, otherwise you have to specify the different port with the syntax Servername\InstanceName,Port or for default instances Servername,Port.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Also, you should have no problems registering the server, but you might have problems connecting to it [either OE or a new QE window]. If so, like the author above noticed, you might be having problems with the port, enabled protocols etc...|||Success! Thanks Jens. I never would've guessed that syntax.

Can't read filename in tabbed environment of Management Studio

When using the tabbed environment in management studio, it automatically includes the server name and database name before the filename (e.g. ServerName.DatabaseName - Query.sql). When you load stored procedures with long filenames into the tabbed environment, only the last few characters are visible in the tab, and you have to hover over it in order to see which file you are looking at. Does anyone know if you can show just the filename on the tabs, so you actually know which file you have selected?

This is a known issue that was raised throught the Beta/CTP process unfortunately I believe it is a limitation of the Visual Studio Shell.

It has improved but ideally the connection and the filename need to be on different lines.

http://www.sqljunkies.com/WebLog/simons/archive/2005/06/21/15885.aspx#comments

Cant preview report

Hi ,
I have a long sql statement(a little bit complicated), but I've tried to
excute it in MS Sql server Management studio and it works correctly then I
put it in the dataset of Reporting services(MS Visual studio) , when I change
the panel to "Preview" ,MS visual studion seems no response and I have to
stop it through the system tool...
Please help! If you have the same experience.
Thanks in advance.
LanceI found a way to deal with this..might be not a best way.
Delete the DATESET and recreate a new one.
"Lance" wrote:
> Hi ,
> I have a long sql statement(a little bit complicated), but I've tried to
> excute it in MS Sql server Management studio and it works correctly then I
> put it in the dataset of Reporting services(MS Visual studio) , when I change
> the panel to "Preview" ,MS visual studion seems no response and I have to
> stop it through the system tool...
> Please help! If you have the same experience.
> Thanks in advance.
> Lance|||On Jan 31, 8:29 pm, Lance <La...@.discussions.microsoft.com> wrote:
> I found a way to deal with this..might be not a best way.
> Delete the DATESET and recreate a new one.
> "Lance" wrote:
> > Hi ,
> > I have a long sql statement(a little bit complicated), but I've tried to
> > excute it in MS Sql server Management studio and it works correctly then I
> > put it in the dataset of Reporting services(MS Visual studio) , when I change
> > the panel to "Preview" ,MS visual studion seems no response and I have to
> > stop it through the system tool...
> > Please help! If you have the same experience.
> > Thanks in advance.
> > Lance
Sounds like you might have performance issues with the report query.
You might try running the Database Engine Tuning Advisor against the
report query to improve the performance via suggested indexes. Also,
if you haven't already, you will want to convert the report query into
a stored procedure. This should improve your report performance as
well. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

can't open SQLserver 2005 express with management studio

Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
studio.
I have an SQL server 2005 express database installed in the server but I
can't acces it with management studio. The error is:
"when connecting to sql server 2005, this failure may be caused by the fact
that under the default settings SQL server does not allow remote
connections-- errror locating Server\Instance"
note that:
- database is installed in the local machine.
- remote connections are enabled
-I CAN access database from my asp.net application and using ODBC attaching
tables in an Access DB
-The instance is: ServerName\SQLEXPRESS
- Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
are enabled.
- Windows firewall is disabled
Thanks for suggestionsFrank wrote:
> Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
> studio.
> I have an SQL server 2005 express database installed in the server but I
> can't acces it with management studio. The error is:
> "when connecting to sql server 2005, this failure may be caused by the fac
t
> that under the default settings SQL server does not allow remote
> connections-- errror locating Server\Instance"
> note that:
> - database is installed in the local machine.
> - remote connections are enabled
> -I CAN access database from my asp.net application and using ODBC attachin
g
> tables in an Access DB
> -The instance is: ServerName\SQLEXPRESS
> - Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapter
s
> are enabled.
> - Windows firewall is disabled
> Thanks for suggestions
Are you running studio manager locally on the same server?|||Yes, I'm running studio manager locally on the same server
"Ken" <kshapley@.sbcglobal.net> ha scritto nel messaggio
news:1158625215.196916.240230@.m73g2000cwd.googlegroups.com...
> Frank wrote:
> Are you running studio manager locally on the same server?
>

can't open SQLserver 2005 express with management studio

Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
studio.
I have an SQL server 2005 express database installed in the server but I
can't acces it with management studio. The error is:
"when connecting to sql server 2005, this failure may be caused by the fact
that under the default settings SQL server does not allow remote
connections-- errror locating Server\Instance"
note that:
- database is installed in the local machine.
- remote connections are enabled
-I CAN access database from my asp.net application and using ODBC attaching
tables in an Access DB
-The instance is: ServerName\SQLEXPRESS
- Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
are enabled.
- Windows firewall is disabled
Thanks for suggestions
Frank wrote:
> Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
> studio.
> I have an SQL server 2005 express database installed in the server but I
> can't acces it with management studio. The error is:
> "when connecting to sql server 2005, this failure may be caused by the fact
> that under the default settings SQL server does not allow remote
> connections-- errror locating Server\Instance"
> note that:
> - database is installed in the local machine.
> - remote connections are enabled
> -I CAN access database from my asp.net application and using ODBC attaching
> tables in an Access DB
> -The instance is: ServerName\SQLEXPRESS
> - Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
> are enabled.
> - Windows firewall is disabled
> Thanks for suggestions
Are you running studio manager locally on the same server?
|||Yes, I'm running studio manager locally on the same server
"Ken" <kshapley@.sbcglobal.net> ha scritto nel messaggio
news:1158625215.196916.240230@.m73g2000cwd.googlegr oups.com...
> Frank wrote:
> Are you running studio manager locally on the same server?
>

can't open SQLserver 2005 express with management studio

Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
studio.
I have an SQL server 2005 express database installed in the server but I
can't acces it with management studio. The error is:
"when connecting to sql server 2005, this failure may be caused by the fact
that under the default settings SQL server does not allow remote
connections-- errror locating Server\Instance"
note that:
- database is installed in the local machine.
- remote connections are enabled
-I CAN access database from my asp.net application and using ODBC attaching
tables in an Access DB
-The instance is: ServerName\SQLEXPRESS
- Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
are enabled.
- Windows firewall is disabled
Thanks for suggestionsFrank wrote:
> Using: Windows 2003 server, SQL Server 2005 Express, SQl server management
> studio.
> I have an SQL server 2005 express database installed in the server but I
> can't acces it with management studio. The error is:
> "when connecting to sql server 2005, this failure may be caused by the fact
> that under the default settings SQL server does not allow remote
> connections-- errror locating Server\Instance"
> note that:
> - database is installed in the local machine.
> - remote connections are enabled
> -I CAN access database from my asp.net application and using ODBC attaching
> tables in an Access DB
> -The instance is: ServerName\SQLEXPRESS
> - Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all adapters
> are enabled.
> - Windows firewall is disabled
> Thanks for suggestions
Are you running studio manager locally on the same server?|||Yes, I'm running studio manager locally on the same server
"Ken" <kshapley@.sbcglobal.net> ha scritto nel messaggio
news:1158625215.196916.240230@.m73g2000cwd.googlegroups.com...
> Frank wrote:
>> Using: Windows 2003 server, SQL Server 2005 Express, SQl server
>> management
>> studio.
>> I have an SQL server 2005 express database installed in the server but I
>> can't acces it with management studio. The error is:
>> "when connecting to sql server 2005, this failure may be caused by the
>> fact
>> that under the default settings SQL server does not allow remote
>> connections-- errror locating Server\Instance"
>> note that:
>> - database is installed in the local machine.
>> - remote connections are enabled
>> -I CAN access database from my asp.net application and using ODBC
>> attaching
>> tables in an Access DB
>> -The instance is: ServerName\SQLEXPRESS
>> - Shared memory, TCP/IP ad named pipes are enabled. For TCP/IP all
>> adapters
>> are enabled.
>> - Windows firewall is disabled
>> Thanks for suggestions
> Are you running studio manager locally on the same server?
>

Cant open Northwinds database diagrams node in SQL MSE

Hi.

I'm very new to this so I apologise in advance for asking the blindibly obvious. I have installed SQL Express and SQL Server Management Studio Express and I have downloaded and attached the Northwind sample database. I can see and edit the data in the tables but when I try to open the Database Diagram node I get the following message:

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

I have no idea what a valid logon would be. Can somebody help?

Thanks

The error is related to compatility level because you attached a 2000 MDF instead of 2005 and the fix is in the link below. Hope this helps.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=85378&SiteID=1

|||

Hi,

No luck. Following the instructions in the link I first tried to change the property by right clicking on the database and selecting properties, but I couldn't find a property that looked relevant. Is it not available in the the Express version of the manager?

I then tried the alternative method provided in the link, and ran the SQL code:

EXEC sp_dbcmptlevel 'Northwind','90'

This appeared to work, in that the following message appeared in the window at the bottom:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

However, I still get the error when I try to create or view database diagrams for Northwind.

|||If you dont have it download and install the advanced, right click on the Northwind in management studio and click on ALTER and generate create database statement and drop the original and execute the new one so you can clean out the 2000 features from it. Hope this helps.

Can''t management maintenance plans in SQL Mgmt Studio

When I click on the "Maintenance Plans" node in SQL Management Studio, I get an error:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

BUTTONS:

OK

As you can imagine, the links take me to a "We're sorry... no additional info available" message. Has anyone else seen this, or better yet, resolved it?

--Geoff

I think you need to have SQL 2005 SP2 refer,

http://207.46.236.188/MSDN/ShowPost.aspx?PostID=1757393&SiteID=1

Can''t management maintenance plans in SQL Mgmt Studio

When I click on the "Maintenance Plans" node in SQL Management Studio, I get an error:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

BUTTONS:

OK

As you can imagine, the links take me to a "We're sorry... no additional info available" message. Has anyone else seen this, or better yet, resolved it?

--Geoff

I think you need to have SQL 2005 SP2 refer,

http://207.46.236.188/MSDN/ShowPost.aspx?PostID=1757393&SiteID=1

cant login to sql 2005 express

when i installed visual web developer and sql management studio,i try to use sql management studio to connect to sql 2005 express,but a error ocurred.here is the error message.

TITLE: Connect to Server
----------

Cannot connect to DH\SQLEXPRESS.

----------
ADDITIONAL INFORMATION:

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data)

----------

The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data)

----------

The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data)

----------

Configuration system failed to initialize (System.Configuration)

----------

Unrecognized configuration section system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 136) (System.Configuration)

and i wonder if anybody has experienced this error can tell me how to solve?

Can you post what in line 136 of your machine.config file?

|||

the following is the part of machine.config

line 136<system.serviceModel>
<extensions>
<behaviorExtensions>
<add name="persistenceProvider" type="System.ServiceModel.Configuration.PersistenceProviderElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="workflowRuntime" type="System.ServiceModel.Configuration.WorkflowRuntimeElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="enableWebScript" type="System.ServiceModel.Configuration.WebScriptEnablingElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="webHttp" type="System.ServiceModel.Configuration.WebHttpElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior" type="Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior, Microsoft.VisualStudio.Diagnostics.ServiceModelSink, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/></behaviorExtensions>
<bindingElementExtensions>
<add name="webMessageEncoding" type="System.ServiceModel.Configuration.WebMessageEncodingElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="context" type="System.ServiceModel.Configuration.ContextBindingElementExtensionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</bindingElementExtensions>
<bindingExtensions>
<add name="wsHttpContextBinding" type="System.ServiceModel.Configuration.WSHttpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="netTcpContextBinding" type="System.ServiceModel.Configuration.NetTcpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="webHttpBinding" type="System.ServiceModel.Configuration.WebHttpBindingCollectionElement, System.ServiceModel.Web, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
<add name="basicHttpContextBinding" type="System.ServiceModel.Configuration.BasicHttpContextBindingCollectionElement, System.WorkflowServices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</bindingExtensions>
</extensions>
<client>
<metadata>
<policyImporters>
<extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>
</policyImporters>
<wsdlImporters>
<extension type="System.ServiceModel.Channels.ContextBindingElementImporter, system.workflowservices, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL"/>
</wsdlImporters>
</metadata>
</client>
<commonBehaviors><endpointBehaviors><Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior/></endpointBehaviors><serviceBehaviors><Microsoft.VisualStudio.Diagnostics.ServiceModelSink.Behavior/></serviceBehaviors></commonBehaviors></system.serviceModel>]

it's no problem.it guess it may be the problem of FrameWork.because when i try to conncet by visual web developer,an error occur.it says Request .net data provider,you may not install.but as we know the .net FrameWork contains the .net data provider. and the visual web developer 2008 beta2 contains .Net Framework 3.5,So i really don't understand.

|||

Hi chance1,

After having consulted some of my collegues, it seems that your web.config file is somewhat corrupted.

The section "system.serviceModel" should be registered like the following (mine is from a 3.0 machine). <sectionGroup name="system.serviceModel" type="System.ServiceModel.Configuration.ServiceModelSectionGroup, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <section name="behaviors" type="System.ServiceModel.Configuration.BehaviorsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="bindings" type="System.ServiceModel.Configuration.BindingsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="client" type="System.ServiceModel.Configuration.ClientSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="comContracts" type="System.ServiceModel.Configuration.ComContractsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="commonBehaviors" type="System.ServiceModel.Configuration.CommonBehaviorsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowDefinition="MachineOnly" allowExeDefinition="MachineOnly" /> <section name="diagnostics" type="System.ServiceModel.Configuration.DiagnosticSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="extensions" type="System.ServiceModel.Configuration.ExtensionsSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="machineSettings" type="System.ServiceModel.Configuration.MachineSettingsSection, SMDiagnostics, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowDefinition="MachineOnly" allowExeDefinition="MachineOnly" /> <section name="serviceHostingEnvironment" type="System.ServiceModel.Configuration.ServiceHostingEnvironmentSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> <section name="services" type="System.ServiceModel.Configuration.ServicesSection, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

</sectionGroup>

I would suggest you to install the same .Net Framework 3.5 on another machine and copied the "machine.config" from the good machine to the machine in question.See if this will work. Please feel free to let me know if you have any further questions. thanks.

|||

thank you Bo Chen .and i did what you suggest in a few days ago.but sadlly, it doesn't work. and later i reinstall xp and vs 2005. and the sql 2005 express works.later i try to install visual web developer express 2008.this time visual web developer 2008 can connect and use the sql 2005 express. but vs 2005 can't work now.but thank you for the people who have helped me.

|||

Hi ,

This problem might occur sometimes due to corrupt installation of sql server 2005. I was also facing the same problem.Uninstall Sql Server 2005 and reinstall it with a different instance(named). Dont try to install with the same instance which u had used previously.Try this and tell me if this works

Thanks & Regards

Keerti Somasundaram

|||

thank you.but before i install sql server 2005,i have reinstall windows xp.and there is no sql 2005 in it. and i think it may be theproblem of visual web developer2008 beta 2.

Cant log into remote server

Hello everyone, I am having issues with connecting to

another database on the same network. I am creating a management system for the

company that I work for and I am currently working on the database side of it

and learning as I go along which means that I am fairly new but I think I have

got the basic concepts.

The system will have multiple databases at different locations.

The idea is for all the databases to have all the same data so that the system

can keep operating if the internet goes down.

The plan is to use the merge replication function within sql 2005 (currently working with the enterprise trial); I think I need to do

publications and subscriptions on all the databases to have the dataflow in 2

directions. In order to do this I need to setup users. I have created 1 user

with the same credentials to the 2 machines that the databases are running

from.

I have linked the users to sql with the correct privileges. I can connect to

one remote database, but when I try to connect to the other I get this message

"Login failed for user 'NEAL-LAPTOP\Guest'. (.Net SqlClient Data

Provider)" other information with this error "Server Name:

NEAL-LAPTOP Error Number: 18456 Severity: 14 State: 1 Line Number: 65536"

keep in mind that the user in not "Guest" and I am logged in as the

correct user.

I would appreciate if anyone can help me out with this

Hi,

you will have to disable the simple file sharing on the server machine. If activated incoming connections will be "authenticated" as the Guest user. Disabling that will force the client to pass the credentials.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de