Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Chad Miller Database Space Capacity Planning RE: Database Space Capacity Planning

  • October 18, 2012 at 9:23 am

    #1550551

    narayanaswamy (10/18/2012)

    Hi All,

    In SQL Server 2008 instance i have created spacedm database and created all objects tables,views,sp's

    I've executed this command prompt .\write-dbspacetodb.ps1 'instancename' spacedm

    I am getting below error from powershell. An exception calling "fill" with "1" can't open database spacedm. Login failed to open Spacedm database

    Please help me how to resolve this issue. I have created one login assigned db_owner to spacedm even then same issue.

    It seems like you're having trouble making a connection. Try just running a test connection:

    $serverName = 'instancename'

    $databasename = "spacedm"

    $connString = "Server=$serverName;Database=$databaseName;Integrated Security=SSPI;"

    $con = new-object System.Data.SqlClient.SqlConnection

    $con.ConnectionString = $connString

    $con.Open()