error when create new database sqlo express

[sal21]

I have installed on my PC SQL EXPRESS 2008 without password.
Now i need to create a new database but have the error in image.
Please...

[HansV]

Try starting SQL Server Management Studio by right-clicking it and selecting 'Run as administrator' ('Esegui come amministratore') from the context menu.

[sal21]

Try starting SQL Server Management Studio by right-clicking it and selecting 'Run as administrator' ('Esegui come amministratore') from the context menu.

tks!
Resolved.

I have sql express 2008 on my PC.
I need to share all database (with read and write permission) to the user of same LAN.
How to?

Note:
sorry but my first experinence on Sql Server

[HansV]

See Procedura: Attivazione dell'accesso alla rete in Gestione configurazione SQL Server (SQL Server Express).

[sal21]

See Procedura: Attivazione dell'accesso alla rete in Gestione configurazione SQL Server (SQL Server Express).

The INSTANCE is mysql0002...
is ok?

But gogling .... i need to set enabled my firewall port 1433, or not?


to test this code work perfect in local, but have a dubt on Cursor type in connection and in recordset:

Code: Select all

Option Explicit
Sub ADO_ACCESS_To_SQLServer()

    Dim CN As ADODB.Connection
    Dim ServerName As String
    Dim DatabaseName As String
    Dim TableName As String
    Dim UserID As String
    Dim Password As String
    Dim RS As ADODB.recordSet
    Dim RIGA As Long

    Set RS = New ADODB.recordSet

    ServerName = "xxxxxxxxx\MYSQL0002"
    DatabaseName = "STAT_L0928"
    TableName = "STATISTICA_SPORT"
    UserID = ""
    Password = ""

    Set CN = New ADODB.Connection
    CN.CursorLocation = adUseServer
    CN.ConnectionTimeout = 99999

    CN.Open "Driver={SQL Server};Server=" & ServerName & ";Database=" & DatabaseName & _
            ";Uid=" & UserID & ";Pwd=" & Password & ";"

    RS.Open TableName, CN, adOpenKeyset, adLockOptimistic

    Do While Not RS.EOF
        RIGA = RIGA + 1
        RS.MoveNext
        DoEvents
    Loop

    RS.Close
    Set RS = Nothing
    CN.Close
    Set CN = Nothing

End Sub

[HansV]

I'm not an expert on SQL Server; I hope that someone else can answer these questions.

[Fluffyone]

Run Microsft SQL Server Studio as an administrator, your problem will be solved