Showing posts with label modify. Show all posts
Showing posts with label modify. Show all posts

Tuesday, March 20, 2012

Cannot create or modify tables in any database ("The parameter is incorrect.")

Using SQL Server 2005 and Microsoft SQL Server Management Studio, I connect using windows authentication. On any database I have created or attached (from a previous version of SQL Server), if I try to add a new table or modify an existing table, I get an error. A dialog pops up that says, "The parameter is incorrect." And I realy can't go any further.

I tried to remedy the problem by applying SP1 (x64) to the installation but I still get the same error.

Has anybody got a clue as to why I get this error? This is not SQL Server Express but the standard version of SQL Server. Fabulous software, I just can't get this to work on this new server. SQL Server Express is wonderful on our test machines but we need to get past this issue to fully utilize the server version.

Thanks for any help somebody can give me.

Please file a defect report on http://connect.microsoft.com/sqlserver. Defects reported on the Connect site go directly into our internal issue tracking system.

The error message pop-up should have a button/icon at bottom to show technical details. This includes the detailed exception message and the call stack. This can help us diagnose the problem. Be sure to include the version number of management studio and the engine (use menu Help | About to see the management studio version, and use this T-SQL to get the engine version: select @.@.version) and the call stack from the error dialog in the defect report.

One thing I would check is whether the database you've attached has a valid owner in the new server. If the database doesn't have an owner, you can give it one using the database properties dialog in management studio (connect to the server, right click on the database in Object Explorer, and select Properties. The owner can be set on the Files page.) or by issuing the "ALTER AUTHORIZATION ON DATABASE::{your db} TO {server principal}" statement in sqlcmd or a management studio query window.

You also need fairly high privileges to modify tables. Can you modify tables if you log in as a database owner?

Thanks,
Steve

Monday, March 19, 2012

Cannot create new roles for users or groups as well as folders

Good afternoon,
I cannot seem to create or modify both roles and folders in Report Manager.
When I click on OK in the form to create or modify existing items nothing
happens. Am I forgetting something?
I had an issue during the installation or RS that may weigh in... the
installation of RS would fail at the final phase and give me an error (25619
- KB Article 867872). There is a knowledgebase article for this. It details
using a parameter to not create the virtual folders for Reports and
ReportServer and how to create the virtual folders and it's permissions
afterwards. This completed the installation and everything else, aside from
this issue, appears to be operatin normally.
Specs:
Windows Server 2003
SQL Server 2000 w/ SP3
SQL RS w/ SP1Disregard... another thread gave me the answer:
on the server run:
aspnet_regiis -c
from the .Net framwork dir.
"Peter Capazzi" wrote:
> Good afternoon,
> I cannot seem to create or modify both roles and folders in Report Manager.
> When I click on OK in the form to create or modify existing items nothing
> happens. Am I forgetting something?
> I had an issue during the installation or RS that may weigh in... the
> installation of RS would fail at the final phase and give me an error (25619
> - KB Article 867872). There is a knowledgebase article for this. It details
> using a parameter to not create the virtual folders for Reports and
> ReportServer and how to create the virtual folders and it's permissions
> afterwards. This completed the installation and everything else, aside from
> this issue, appears to be operatin normally.
> Specs:
> Windows Server 2003
> SQL Server 2000 w/ SP3
> SQL RS w/ SP1
>

Thursday, February 16, 2012

Cannot connect to sql database using Config app tool.

hi AllI'm new comer , the first time to work with Ent lib , I try to use modify sql connection string using configuration application tool integrated in Visual Studio against sql server 200 , I got this error .

_http://imagesshared.com/images/jdv1192388741v.JPG

I don't know how to solve my problem , someone please help me to overcome this problem .Thanks in advance .sorry for my poor English , I'm a Vietnamese student .

The problem is that you're trying to connect to a Sql server express user instance, but you're in fact using Sql Server 2000. You can modify your connection string to work with sql server 2000, or you can download and install sql server express - this is a free download from here:http://msdn2.microsoft.com/en-us/sql/Aa336346.aspx .

|||

DO the following modification in the Connection String of the App.Config / Web.config ...

Remove the AttributeUser Instance =true from the connection string that should solve the issue

|||

Thanks Svante , skurocks for replying

Then I solved my problem , thanks skurocks|||

Hi All

I got this error when I try to display whole record of customers table into GridView .

_http://imagesshared.com/images/opt1192519086n.JPG

This is the first time I work with Ent Lib 3.1 .

Here is my source code , please help me and explain to me why this error occur .

_http://www.4shared.com/file/26591127/38feb983/WebSite1.html?dirPwdVerified=814e49b

Thanks in advance for your time .

.........

Regards